Power BI dataset into Alteryx

[rbaguer]

Can we import a Power BI dataset as an input in Alteryx? Would that transfer the connections between the different tables established within the dataset ifself?

[BrandonB]

The list of Alteryx supported Data Sources can be found here: https://help.alteryx.com/2020.1/DataSources/SupportedDataSources.htm

At the moment, PowerBI is only officially supported as something that Alteryx writes OUT to: https://help.alteryx.com/2020.1/DataSources/PowerBI.htm

In order to read data from PowerBI, they would need to make it available via their REST API which I don't believe is currently available: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7775832-rest-api-access-to-read-d...

However, it is likely that the sources which make up the PowerBI dataset can be connected to via an Alteryx workflow so this would be the most appropriate route to take. 

[JohnOrton1990]

Has there been update where PowerBI can be an input into Alteryx?

[prashan29]

Has there been update where PowerBI can be an input into Alteryx

[Jeff1966]

I would also like to know the status of this.  When we look at the completed dataset it could contain multiple data sources.  Plus, when you look at the underlying code / formulas built into the existing dataset there's no need to reinvent this in Alteryx.  For myself I have a need to take an existing output from one dataset combine it with another then combine it with other reports be it Excel or another format to produce a final output for our Enterprise.  This is where Alteryx could come in.

[JessieC]

@rbaguer @JohnOrton1990 @prashan29 @Jeff1966 - Microsoft recently updated their PowerBI APIs this year (

https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-the-executequeries-rest-...

), so please vote for the idea/give feedback here directly to our product team - https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Power-BI-Input/idi-p/769715 . Also, since there is a REST API option now, it is possible to build your own connector via the Download / R / Python tool if the need is urgent