750
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
STATUS DETAILS
Needs Votes

Comments

M

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.

M

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

M

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.

M

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

M

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

M

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.

M

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

M

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.

M

essential for prototyping - please give me this for xmas.

M

This is a MUST have guys!