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.
Felipe Kirsch Hoerbe commented
This feature would help so much in several use cases where Excel is a better tool to simulate what-if scenarios!
Ed Hansberry commented
FWIW, in the Office 365 Insiders build of Excel, Power Query has a "Power Platform" menu as a data source that is grayed out, and one of the members on the team said functionality was coming. I would hope that would include Power BI data sets, Data Flows, and CDS, just like it does on Power BI Desktop. I keep checking every week. It first showed up a month or so ago, or at least that was when I first noticed it. So it is coming....
It's bizarre that Excel can now easily connect to virtually any data source other than Power BI, must be a decision made by MS to try to push people into using PBI desktop. Not good for the huge number of use cases where only Excel will do which results in an awkward two-step process for users to download data form PBI then copy/paste into Excel. We have PBI reports built just for this purpose :(
Analyse in Excel is only really a halfway solution which causes us more problems than its worth in most cases
Nick Doy commented
Is there a timescale for this? It must be on a roadmap somewhere....
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!