Skip to main content

Power BI

Completed

Connect to Dataflows from Excel's Power Query

Vote (1040) Share
Michael Shparber's profile image

Michael Shparber on 26 Apr 2019 19:12:38

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

Administrator on 12 Sep 2022 07:23:49

Released.

Comments (108)
Michael Shparber's profile image Profile Picture

Andy McCourt on 06 Apr 2022 15:28:08

RE: Connect to Dataflows from Excel's Power Query

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.

Michael Shparber's profile image Profile Picture

Mathew Westwood on 29 Mar 2022 14:29:59

RE: Connect to Dataflows from Excel's Power Query

Any update?

Michael Shparber's profile image Profile Picture

Scott Stewart on 21 Mar 2022 17:52:44

RE: Connect to Dataflows from Excel's Power Query

Any update?

Michael Shparber's profile image Profile Picture

Henry Gabriel on 25 Feb 2022 23:01:04

RE: Connect to Dataflows from Excel's Power Query

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

Michael Shparber's profile image Profile Picture

Ivy Araneta on 22 Feb 2022 20:12:41

RE: Connect to Dataflows from Excel's Power Query

Can the Admin please update the Planned Release date for this feature? This feature is still not available as per link below.https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16

Michael Shparber's profile image Profile Picture

William Rathbone on 15 Feb 2022 10:39:20

RE: Connect to Dataflows from Excel's Power Query

Given this feature is in Power BI already it should be easy to add to Excel? Alternatively a CDM connector from Excel would allow us to take the manual approach having connected the Dataflow to Azure storage but seems ugly?

Michael Shparber's profile image Profile Picture

Lucas Ferreira on 03 Feb 2022 16:22:26

RE: Connect to Dataflows from Excel's Power Query

When will this be implemented? Urgently required

Michael Shparber's profile image Profile Picture

Tom Hall on 31 Jan 2022 16:05:19

RE: Connect to Dataflows from Excel's Power Query

any news?

Michael Shparber's profile image Profile Picture

Martin G on 24 Jan 2022 15:34:38

RE: Connect to Dataflows from Excel's Power Query

Hello! Second half 2021 is sort of kind of over... any updates? :)Keep it up!

Michael Shparber's profile image Profile Picture

Анатолий Игнатченко on 29 Dec 2021 15:17:02

RE: Connect to Dataflows from Excel's Power Query

https://www.thebiccountant.com/2021/01/24/workaround-to-connect-to-power-bi-dataflows-from-power-query-in-excel/

posted 2021-01-24