Add Power BI Dataflows as a data source in "Get & Transform Data"
Please add Power BI Dataflows as a data source so that I can import data from a Dataflow into the local spreadsheet/data model.
They updated Power Query for Excel on Office 365 1907 (compilation 11819.200002 insider build) and added a currently deactivated Power BI source. Maybe they are up to something, but I couldn't find a related M function for that option.
+1 isn’t the whole idea behind power platform to let folks build their own data source of truth? I need business office users able to build financial reports and reconcile from same data sources specified in Power BI data flows. Please?!
Chris Webb commented
I think dataflows would be a really good way of exposing tables of data for Excel users in situations where access to the underlying data source is not possible, or where it's important to extract the data from the data source only once (regardless of how many end users need to use the data) for performance reasons or to ensure consistency between users. Surely this must be easy to implement given that dataflows are already available for Power Query in Power BI?
It would be awesome if one could connect excel to data flows. Just do it!