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

Hugo MICHEL on 17 Jan 2021 14:54:03

RE: Connect to Dataflows from Excel's Power Query

Hi so I don't see the feature even though it is market as completed. Can you advise ?

Michael Shparber's profile image Profile Picture

Maikel de Bekker on 07 Jan 2021 14:59:48

RE: Connect to Dataflows from Excel's Power Query

I can't find anywhere how to connect a PBI Dataflow with Power Query in Excel as it says this idea is completed. where can I find this?

Michael Shparber's profile image Profile Picture

Mark Paradis on 08 Dec 2020 20:16:48

RE: Connect to Dataflows from Excel's Power Query

I see this was completed as of today, will there be a rollout of O365 for Excel to recognize the connector?

Michael Shparber's profile image Profile Picture

Bard Cloete on 01 Oct 2020 09:08:01

RE: Connect to Dataflows from Excel's Power Query

I concur

Michael Shparber's profile image Profile Picture

Ralph West on 21 Sep 2020 17:55:50

RE: Connect to Dataflows from Excel's Power Query

Please add

Michael Shparber's profile image Profile Picture

Shiva Kumar NT on 04 Sep 2020 14:19:28

RE: Connect to Dataflows from Excel's Power Query

This would be a great feature

Michael Shparber's profile image Profile Picture

Gavin Doyle on 04 Sep 2020 04:23:03

RE: Connect to Dataflows from Excel's Power Query

This would provide a great opportunity for single source of truth data for both Power BI and excel users.

Michael Shparber's profile image Profile Picture

James Daily on 25 Aug 2020 00:31:09

RE: Connect to Dataflows from Excel's Power Query

This idea represents the second half of the migration story for using Dataflows instead of Excel Power Query for data preparation. There is documentation here on how to migrate the data preparation to the service:
https://docs.microsoft.com/en-us/power-query/dataflows/how-to-migrate-queries-from-power-query-desktop-to-dataflows

Unfortunately the documentation only shows you how to move away from Excel for the queries, but not how to consume the results when you still need them in Excel. A lot of heavy lifting or standardization can be done in the service, but a lot of users still need to consume the final result as Excel content.

A native connector would be ideal for keeping things simple for Excel users. Maybe it could work like the Dynamics 365 (current environment) when targeting the built in (transparent) ADLS gen2 capacity backing the workspaces. Anything that can abstract away the complexities of the underlying common data model folders would make it easier for the typical Excel business user to consume the final result.

Michael Shparber's profile image Profile Picture

Maarten Heymans on 06 Aug 2020 11:32:48

RE: Connect to Dataflows from Excel's Power Query

we would like to see this happen

Michael Shparber's profile image Profile Picture

Peter Wilson on 28 Jul 2020 08:15:58

RE: Connect to Dataflows from Excel's Power Query

This would be a great feature