712
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

I concur

M

Please add

M

This would be a great feature

M

This would provide a great opportunity for single source of truth data for both Power BI and excel users.

M

This idea represents the second half of the migration story for using Dataflows instead of Excel Power Query for data preparation. There is documentation here on how to migrate the data preparation to the service:
https://docs.microsoft.com/en-us/power-query/dataflows/how-to-migrate-queries-from-power-query-desktop-to-dataflows

Unfortunately the documentation only shows you how to move away from Excel for the queries, but not how to consume the results when you still need them in Excel. A lot of heavy lifting or standardization can be done in the service, but a lot of users still need to consume the final result as Excel content.

A native connector would be ideal for keeping things simple for Excel users. Maybe it could work like the Dynamics 365 (current environment) when targeting the built in (transparent) ADLS gen2 capacity backing the workspaces. Anything that can abstract away the complexities of the underlying common data model folders would make it easier for the typical Excel business user to consume the final result.

M

we would like to see this happen

M

This would be a great feature

M

Great enhancement expected !!
This would be perfect

M

This would be perfect

M

Por favor es una locura no poder tomar como fuente de datos un dataflow de power services