Forum Discussion
Connect to a Dataflow with Excel Power Query
Hello friends,
How do I connect to a Dataflow table from Excel Power Query?
I don't see the same connectors as I see in Power BI - maybe I can install smth.?
Thanks!
Michael
Hi michaelshparber ,
Based on my test, it is not supported yet currently.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideasIt hasn't been properly rolled out yet, but I've figured out how it can be done (and it's really easy!). Not sure if this has been fully rolled out inside excel yet, I'm using excel 365 and it's working for me.
In excel, do Get Data -> Other Sources -> Blank Query.
The first line of your query needs to be:
=PowerPlatform.Dataflows(null)
If you've ingested a dataflow into Power BI before, this navigation will start to look very familiar. You'll need to sign in with your organisational account, and then you should see a table in the previous window show the records "Workspaces" and "Environments". Click "Workspaces", then under the "Data" field select "Folder" and it will drill down to the next level. You can keep navigating down in the same way, but I find the easiest way to continue is to then click the Navigation Cog in the "Applied Steps" box and navigate exactly the same way that you would do in Power BI.
Power Query Dataflow Navigation
Congratulations! You've just connected Excel Power Query to your Power BI Dataflow! You can now interact with the dataflow in PQ exactly as you would any other source, and once you're done you can Load your data directly into your data model or a tab as usual.
24 Replies
Hi michaelshparber ,
Based on my test, it is not supported yet currently.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideasThanks,
I've opened a new Idea. Please vote for it here:
It hasn't been properly rolled out yet, but I've figured out how it can be done (and it's really easy!). Not sure if this has been fully rolled out inside excel yet, I'm using excel 365 and it's working for me.
In excel, do Get Data -> Other Sources -> Blank Query.
The first line of your query needs to be:
=PowerPlatform.Dataflows(null)
If you've ingested a dataflow into Power BI before, this navigation will start to look very familiar. You'll need to sign in with your organisational account, and then you should see a table in the previous window show the records "Workspaces" and "Environments". Click "Workspaces", then under the "Data" field select "Folder" and it will drill down to the next level. You can keep navigating down in the same way, but I find the easiest way to continue is to then click the Navigation Cog in the "Applied Steps" box and navigate exactly the same way that you would do in Power BI.
Power Query Dataflow Navigation
Congratulations! You've just connected Excel Power Query to your Power BI Dataflow! You can now interact with the dataflow in PQ exactly as you would any other source, and once you're done you can Load your data directly into your data model or a tab as usual.
Hi,
I read it is now possible to connect Excel PQ to dataflows, do you guys know how to ? I can't find "dataflow" as data entry option in excel (it says I have the latest version).
Regards
Hugo
Did you ever figure this out? I'm also very interested in finding a way to connect Excel to a DataFlow. I'm getting very tired of using different data sources when I have to use Excel rather than Power BI.
Hello, yes so it has not been released yet but should be in march:
Looks like you have the same build I do (2108). I think we need to wait for our next Excel update before this will work.
