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)

f2bb22f7 9934-42b8-a5c0-0612a8527bb8 on 06 Jul 2020 00:07:01

RE: Connect to Dataflows from Excel's Power Query

Strong support for this idea. Mentioned ability sound perfect. Now I have to connect Excel with SQL and repeat normalisation all the time I need separate excel using still same data but for another user with different view. Dataflows connector in excel will allow me to use dataflows across all my tasks.

623223b8 5931-4096-8890-801046aded54 on 06 Jul 2020 00:06:31

RE: Connect to Dataflows from Excel's Power Query

Excel's Power Query should be totally aligned with the Power BI Power Query capabilities.

de9aa401 3fbd-4c8c-850b-c481d5b104a1 on 06 Jul 2020 00:04:54

RE: Connect to Dataflows from Excel's Power Query

agree this should be a thing! The PBI add in is great, but can only connect to report or dataset.

bf79304c 23cb-4bfd-8764-276eb12cf2e7 on 06 Jul 2020 00:04:49

RE: Connect to Dataflows from Excel's Power Query

This feature would help me a great deal for entry level excel and power bi users where they don’t have to “struggle” when building queries, creating relationships etc etc.