How do I pull data from PowerBI?

[ALT_2358]

I need to pull data from PowerBI as PowerBI is able to connect to a system that Alteryx isn't able to. Is there a way to pull from PowerBI as an input?

[helpplease]

I had the same issue as we moved to Dynamics AX. Found I had to query the raw SQL tables which took a lot of set up by IT. My understanding is that PowerBI was itself a query of AX, so not possible to query PowerBI. Would be interested to hear a solution, but I am 99.9% sure there is not one.

[LD]

Hello, I was about to post the question on how to pull data from a published PowerBI Dataflow / dataset : do you confirm this is what you are also unsuccessfully tried to achieve (e.g. without connecting directly to the raw SQL source) ?

Thank you !

[ALT_2358 · Accepted solution]

Sorry, should have posted an update on here about it. 

I thought of a way to get everything into Alteryx - haven't implemented it fully yet but some initial tests have proven positive. 

You can set up 'paginated reports' using Power BI to automatically email an Excel file to yourself (cannot automatically export to a file location, can only send out an email) on a schedule. Then you can set up a MS Flow to automatically save the Excel file into OneDrive/SharePoint/Teams. If you add that file location to your computer as a network location or a synced location through OneDrive, you can then get Alteryx to pick up the latest one. 

[LD]

wow, what a workaround! thanks for sharing.

[ALT_2358]

No problem!