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.
Thanks everyone for showing a lot of passion about Dataflows data connector in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.
Principal Program Manager
Game changer! thanks for listening!
Great posts @Imke !
@Imke this is fantastic news! This can not come soon enough!
Imke Feldmann commented
Fortunately this feature made it on the roadmap: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/cdm-data-integration/power-platform-dataflows-connector-excel
But for those who cannot wait for it, here is a workaround: https://www.thebiccountant.com/2021/01/24/workaround-to-connect-to-power-bi-dataflows-from-power-query-in-excel/
Wyn Hopkins commented
The new Power Query Rich Data Types functionality should be added here also rather than via the “featured table” option in Power BI
This feature solves a very specific use case for Power BI. It allows for centralized use of Dataflows and allows Excel to sync the content local and serve as a local cache when offline. We have several scenarios where data needs to be analyzed in dark sites. Using Excel to serve as an offline dataflow makes it really easy. Surprised it's not there already.
This is a much needed update.
Deepak Agrawal commented
Fully agree with Phil's observation. It's going to cost MS heavy in long term ignoring Excel (PowerPivot specifically) and pushing for Power BI.
Seems like this would be easy to implement but MS have an agenda to force usage of Power BI, would be good to get a full explanation for the decision from MS though.
I'm assuming this is driven by MS wanting to get their Power BI user numbers up even if most of them are just pressing export and pasting the data into a spreadsheet. They dont care that it makes the user experience much much worse.
IMO the current (and planned from what I have seen) Excel integration into PowerBI is a mess thats holding back the full adoption of Power BI for the provision of corporate datasets.
Bill Cary commented
Also disappointed. There seems to be a big disconnect between the data repositories Microsoft is emphasizing, and the capabilities of Excel. This is unfortunate.
Thanks for the response from Excel team on 9/23/2020, but extremely disappointed.
This would same so much time. We have moved most of our Power BI data into dataflows, but also have Excel users who user the same or similar data. It would save so much time to have this option and make the whole Microsoft offering more appealing.
Allen Wood commented
This is a must for power users throughout the business who have not yet made the move to Power BI desktop.
There's so much I can't do in PBI that I can knock up in 5 minutes in Excel. If I could tap into a dataflow, I would be so much more productive. The sheer number of workarounds I have to devise to get PBI to display what Excel can do natively is staggering.
Is this even being considered? What is the holdup? It seems like the perfect way of getting excel users and power bi users to report and do analysis on the same data source.
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.