Connect to Dataflows from Excel's Power Query
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.
Zach van Dorp commented
Very keen to get access to this too! Would solve a bunch of problems.
Yes please - the are numerous use cases where this would be really useful
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.
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.
This would be good idea and it would help complete the whole vision/functionality of Dataflows and drive adoption.
we try to use dataflow as our data lake, data depository, and can be used by either Power BI reports or Excel users.
Need this to be available
Must to be available
connect to dataflows from both Excel and Excel Power Query would be ideal.
Martin G commented
Very important to data model prototyping together with Excel users - they are used to seeing data in a certain way.
This is a half-way house for them to help with validation of data before they get Power BI reports which look and feel very different to what an Excel user is used to.
Further, it might even enable historical Excel type use-cases on larger datasets. Please, Redmond. Listen up!
Will be great to have it. Speed of Power Query in Excel to process data is so slow when you need to shape the data.
Nick Doy commented
It would also be useful to Power BI users too.