Power BI

Needs Votes

Connect to Dataflows from Excel's Power Query

Vote (683)

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

Comments (53)

Comments (53)

316bdae3 c512-4cff-a847-b5f3b44df452 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.

e696a490 fd44-46ef-83b2-961c9c118909 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

277d059b 7459-4329-85c8-828a44400009 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.

25d67b33 87d2-46b6-ac99-a69bd762ff45 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.