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

Fritz Koszik on 06 Jul 2020 00:04:27

RE: Connect to Dataflows from Excel's Power Query

This would really help to automate many things. Complex Power Queries can run scheduled in the cloud once instead of 100 times on individual Excels.

Michael Shparber's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:05

RE: Connect to Dataflows from Excel's Power Query

essential for prototyping - please give me this for xmas.

Michael Shparber's profile image Profile Picture

Faruq on 06 Jul 2020 00:03:50

RE: Connect to Dataflows from Excel's Power Query

This is a MUST have guys!

Michael Shparber's profile image Profile Picture

Megan Steele on 06 Jul 2020 00:03:30

RE: Connect to Dataflows from Excel's Power Query

Yes please!

Michael Shparber's profile image Profile Picture

Richard on 06 Jul 2020 00:03:14

RE: Connect to Dataflows from Excel's Power Query

yes yes yes!

Michael Shparber's profile image Profile Picture

Zach van Dorp on 06 Jul 2020 00:02:33

RE: Connect to Dataflows from Excel's Power Query

Very keen to get access to this too! Would solve a bunch of problems.

Michael Shparber's profile image Profile Picture

Power BI User on 06 Jul 2020 00:01:43

RE: Connect to Dataflows from Excel's Power Query

Yes please - the are numerous use cases where this would be really useful

Michael Shparber's profile image Profile Picture

Selim Targay on 06 Jul 2020 00:01:24

RE: Connect to Dataflows from Excel's Power Query

This connector should have been available as soon as MS launched dataflows. It's only half-implemented with access to the dataflow not available in Excel.

Michael Shparber's profile image Profile Picture

Andriano on 06 Jul 2020 00:01:21

RE: Connect to Dataflows from Excel's Power Query

Ideally in Excel's Power Query should be all data sources like in latest Power BI release Power Platform category with Power BI Dataflow, Power BI Dataset and Common Data Services in it. And even better - drivers to connect from external applications (for example from Python/R scripts) to all Power Platform sources.

Michael Shparber's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:56

RE: Connect to Dataflows from Excel's Power Query

This would be good idea and it would help complete the whole vision/functionality of Dataflows and drive adoption.