Pulling data from Power BI to JMP

Peter_Hersh

Has anyone had success pulling data from Power BI into JMP?  I know you can do the .csv export from power BI, but the customer was hoping for a more streamlined process.

I thought this would be easy to do similar to pulling data from Excel via and ODBC connection.  I was not able to find and ODBC driver for Power BI.  We explored using a rest API it seems the authentication method used is not one JMP recognizes.  Maybe there is a Python route, but wanted to check with the community before going down that route.

martindemel

Hi Pete, 

I think it is important to know if it is Power BI Desktop or Cloud. However there seem to be several ways to get data from Power BI. In this article there is an overview I found quite good to see the different options (in the article they focus on Power Shell, but the first part is the general overview): https://www.powershell.no/power/bi,/powershell/2020/02/29/power-bi-powershell.html 

They seem to use an XMLA endpoint to connect and extract the data. 

You might need to check in addition the security settings in Power BI as the role specified decides what you are allowed to access. 

Not the full answer but maybe something for the next step