Connect KNIME to Microsoft Power BI Data

[luiscu]

Hi all, I need to load to KNIME the data from a Power BI data model (pbix file). I didn’t find any KNIME Extension so I’ve been looking around and I’ve only found a way to connect via ADOMD using Python.
Note: Power BI data engine is Microsoft Analysis Services.
Any better idea?

Thanks

PS. I’m not an expert so I’d like to avoid programming from scratch

[luiscu]

Someone else interested? I’ve found so far:

Enable the SQL Analysis Services JDBC Driver in KNIME

http://www.jdbc4olap.org/faq.html

I’ll try.

[Iris]

You can also connect to PowerBi via REST. My colleagues discussed this here

PowerBI Integration

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

PowerBI

Hello all, I seem to be stuck in a school project. I have created a linear regression model in knime and I want to use it to report in powerBI. Can anyone help me in doing so? I have scanned through a lot of posts but cant seem to figure it out.Some people say to write to database and there are some posts regarding rest API. I am a new user of both powerBI and Knime and would appreciate the help immensely. I basically want to take the predictor model i have made and output the results in power…

[luiscu]

Thanks Iris but what I would need is sending data from PowerBI to KNIME.
The mentioned examples using REST would be useful to send data from KNIME to PowerBI

[Haystack]

Hi Luiscu, did you find a solution to your problem? I would also like to connect to a Power BI dataset. Maybe using Azure Blob storage node to connect to Azure Gen2 account where the data lives? Has anyone tried that?