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

Brice Schneider on 06 Jul 2020 00:09:50

RE: Connect to Dataflows from Excel's Power Query

Would be a very usefull feature.

Michael Shparber's profile image Profile Picture

John Nickell on 06 Jul 2020 00:08:47

RE: Connect to Dataflows from Excel's Power Query

Please implement this as we are looking to use Dataflows as a light data warehouse. Not being able to pull this into Excel cripples Dataflows in filling this function.

Michael Shparber's profile image Profile Picture

Louise Allen on 06 Jul 2020 00:08:31

RE: Connect to Dataflows from Excel's Power Query

Definitely have a need for this. There are a number of instances where what I need to produce is achievable in Excel but not PBI. PBI needs to be properly integrated into the Office suite so we can pull data into all applications as appropriate.

Michael Shparber's profile image Profile Picture

James on 06 Jul 2020 00:08:09

RE: Connect to Dataflows from Excel's Power Query

With the pace of both Microsoft Office and IT release cycles, I wonder if the existing ODBC connector and the following idea could help provide a quicker time-to-market to serve this need:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39704425-ODBC-driver-to-connect-to-a-Dataflow

Even with the potential for a more generic ODBC Dataflows driver, a native connector makes a lot of sense to help keep feature parity in the Power Query codebase in PowerBI Desktop and Excel.

Michael Shparber's profile image Profile Picture

Louis Duchesneau on 06 Jul 2020 00:07:10

RE: Connect to Dataflows from Excel's Power Query

We shouldn't need to ask. ;) Go!

Michael Shparber's profile image Profile Picture

Tomasz Pagacz 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.

Michael Shparber's profile image Profile Picture

NaMa 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.

Michael Shparber's profile image Profile Picture

Kim 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.

Michael Shparber's profile image Profile Picture

Power BI User 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.

Michael Shparber's profile image Profile Picture

MJ Zou on 06 Jul 2020 00:04:47

RE: Connect to Dataflows from Excel's Power Query

This is really important!! Please add this!!!