PowerBi Dataset to Alteryx

[bickerch]

Is there a way to connect my PowerBi data set to my Alteryx workflow?  Trying to avoid copying/pasting into excel.

[ShankerV · Accepted solution]

hi @bickerch 

As far as I know, we will not be able to input from Power BI unlike where we can output using PowerBI tool.

The Input option is still under ideology and the link below is for your reference:

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Power-BI-Input/idi-p/769715

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[PanPP · Accepted solution]

Hi @bickerch 

As of right now, there isn't a way to bring in PowerBI data via a connector tool into Designer.

Please see this community post and like the post, if you would like to see this feature implemented into Designer in the future. This feedback will go directly to our product team.

1) 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. 

2) Since there is a REST API option now, it is possible to build your own connector via the Download / R / Python tool in order to connect to PowerBI.

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

Hope this helps. If it does please like the post and mark it as a solution.