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
I hope this gets done because we have great use cases for data flows, but there's no point implementing them if they don't also work in Excel. Power BI popularity has exploded where I work, but the core is still Excel and almost all analysis ultimately ends up there.
If Microsoft is trying to steer folks toward PBI by limiting the Excel PQ connectors, all they're really doing is limiting the user base for their own features. PBI is great but it's never going to be the "go to" tool like Excel is. The UI is just way too slow and clunky and the sharing too complex for the average analyst.
If Excel can connect to data flows, we can deliver curated datasets to both sets of users (Excel and PBI) and give them a consistent experience.
Actually based on the change of of the 2020-release-wave2, this was "Moved to the next release wave" (https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/change-history), but it is nowhere to be found in 2021-release-wave1... @GuyHunkin can you please share why this is?
It was marked as complete but not in a list of release... seems like removed. We really need this. We using Dataflow to prepare and transform data for BI reporting but need use them for finance calculations as well. Many third party systems requred import files in Excel format. Using Data flow will unify all data in single source fir BI/integration purposes. Currently we need have Dataflow transforming various data for BI reporting, then use PQ in Excel connect to same data and transform data again to use for other business needs. Sharing, consuming data is complicated and confusing, business hates this. Why this can’t be more simple for end user-business ??
Did this get dropped? no longer seems to be in the roadmap?
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!