Forum Discussion
Connect to a Dataflow with Excel Power Query
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.
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.
I can confirm that this works in Office 365. It's not exposed in the UI, but you can navigate to the Dataflows you have access to. I tried this same approach months ago (writing M code directly) and got an error message instead.
Not working for me. Which build of Excel do you have? I have Version 2108. The M code results in an error. =PowerPlatform.Dataflows(null)
Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bit
Did anyone work out when this will be implemented or a work around?
i ahve tried to use the suggested: =PowerPlatform.Dataflows(null) - but this doesnt work and just errors.
