1010
Please allow the connection to Dataflows' entities from Excel's Power Query.
There are many cases when customers use Excel and not Power BI. But Dataflows can make the refresh process much faster for them.
Thanks
STATUS DETAILS
Planned
2021 Release Wave 2

This feature is planned for the second half of 2021. Stay tuned!

Comments

M

Any updates? It was supposed to be in 2021. This seems like a slam-dunk easy thing, why wouldn't a MS data source (dataflows) not be supported in a MS product?


It's very annoying and not good practice to create a Dataset linking to a Dataflow just to source data into Excel since only Datasets are supported.

M

Does the OP know when this will be implemented? 2021 was 5 months ago and still nothing. I am desperate to get to the PF data in excel.

M

But it seems no query folding (yet?) :-(

M

Works for me!! Never thought this day would arrive...LOL

M

It could be that it hasn't rolled out to all versions yet - I'm working on version:


Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bit 

M

Hey tried the method as stated in previous post::


"In excel, do Get Data -> Other Sources -> Blank Query.

 

The first line of your query needs to be:

 

=PowerPlatform.Dataflows(null)"


Getting expression error:

Expression.Error: The name 'PowerPlatform.Dataflows' wasn't recognized. Make sure it's spelled correctly.


Note: This is testing on Excel 365


Anyone else successful in connecting? If so how so?

M

Just been playing around with this. It looks like the functionality hasn't been properly rolled out and announced yet, but it can be done (and it's really easy!). Also, not sure if this has even 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.


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.

M

Any update?

M

Any update?

M

Just echoing a lot of comments here--this is very important and would love an update.