PowerBI Integration

Hi Nagaraja,

The KNIME REST Web Services nodes are part of the open source KNIME Analytics Platform. You might have to install the extension from KNIME Labs, but this does not require any additional license.

Cheers,

Roland

Hi Roland,

 

Can you please tell me How do I do it in brief?

My requirement is to get the Prepared data from KNIME to Power BI.

 

Thanks,

Hi Roland,

Even I have a similar requirement. Connecting the data prepared in KNIME to Power BI. An example would be much appreciated.

Thanks in advance.

Vijay

Yes I agree It would be interesting yo see both tools

Hey

 

Can somebody please reply for this?

 

 

Thanks,

Nagaraj

Hello,

Any updates on connecting the data prepared in KNIME to Power BI?

Thanks,

Divya

Hi there, also from my side it would be interesting to know how to connect to Power BI. Thanks and best regards, Marc

Hello @Marc_Michaelis,

You have to use either the Web Connector or a Power Query to import data from KNIME rest api. You can see some examples here:

I agree it would probably be good to see an example of this in KNIME.

Best,
Haystack

Hi Roland,
Do you have any examples of how to set this up? This seems to be a common request, haven’t seen a solution on the forum yet.
Thanks!

Hi All,

I use Knime to manipulate the data and write the data in the sql database and from there I read the information with the power BI, the easier way to make this works.

2 Likes

With KNIME 4.1 release KNIME Power BI Integration is now available.

8 Likes

Once I publish Knime tables as a Power BI dataset it´s not possible to config the relationships among tables in Power BI desktop. Any ideas to do that?

Hi @rafaelesanto83,

See this topic: Power BI Table Relationships

It is not yet possible to define the relationships in the KNIME node and once the dataset is uploaded it cannot be changed. We are working on supporting relationships.

Best
Benjamin

6 Likes

Enabling defining of relationships in Power BI node would be so beneficial as right now it’s a real constraint. Any idea as to when this modification may come out? Thanks

Hello @dpowyslybbe,

don’t know about time frames but have added +1 to existing ticket for you (Internal reference: AP-14326).

Br,
Ivan

2 Likes

Hi @bwilhelm, table relationships would be a great addition to the Power BI integration! Thank you so much!

Best,
Haystack

1 Like

Hello @dpowyslybbe, @Haystack, @rafaelesanto83 and other Power BI users,

with new KNIME version 4.4.0 Send to Power BI node has been enhanced with possibility to define relationships. Additionally it has been moved out of Labs. Give it a try and as always feedback is welcome!

Check out here for more together with list of other nodes moved out of Labs:

Br,
Ivan

3 Likes

Hi Ivan,

This is great news! So happy to hear that relationships can now be defined in the Send to Power BI node! Thank you for continuing to improve KNIME + Power BI integrations. @ipazin

Best,
Haystack

2 Likes

Great!!!

To make this node even better, it’s possible in the future enable authentication using service principal?

I believe that this conector use a push method. The disvantage of this it’s the restriction to improve the model using other tools like tabular editor, ALM etc. It’s also possible to create an option to use Tabular Object Model (TOM)?

Many thanks!

1 Like

Hi @rafaelesanto83,

Thank you for the suggestions. I noted them down and we will look into it!

1 Like