Skip to main content
Microsoft Idea

Power BI

Completed

Connect to Dataflows from Excel's Power Query

Vote (1040) Share
Michael Shparber's profile image

Michael Shparber on 26 Apr 2019 19:12:38

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

Administrator on 12 Sep 2022 07:23:49

Released.

Comments (108)
Michael Shparber's profile image Profile Picture

Éric Harvey on 16 Dec 2021 20:12:49

RE: Connect to Dataflows from Excel's Power Query

Only datasets are available on my side as well unfortunately. I don't see any information about this feature anywhere in Microsoft's documentation/roadmap beside this thread.

Michael Shparber's profile image Profile Picture

Ricardo Ferraro on 15 Dec 2021 17:59:37

RE: Connect to Dataflows from Excel's Power Query

Hi community, today I started to see a "From Power BI" / Get Data in Excel´s menu. But as far as I could check, the list of data sources shown after the connection contains only "datasets". Is this what you are seeing on your side ? If so, does this means that we still doesn´t have a connector to Power BI´s dataflows ? Best.

Michael Shparber's profile image Profile Picture

Andy McCourt on 14 Dec 2021 16:28:08

RE: Connect to Dataflows from Excel's Power Query

Seems like the administrator who changed this to Planned has disappeared? I can't see it on the release wave anymore.

Michael Shparber's profile image Profile Picture

Ricardo Ferraro on 09 Dec 2021 19:51:09

RE: Connect to Dataflows from Excel's Power Query

Hi Community, nice to meet you here. I would like to remind that second half of 2021 ends in like 22 days. Will this planning be attended in this time window ? Best regards.

Michael Shparber's profile image Profile Picture

Andy McCourt on 30 Nov 2021 12:30:55

RE: Connect to Dataflows from Excel's Power Query

Are there any updates to this? Can't see it on the 2021 Release Wave 2 schedule?

Michael Shparber's profile image Profile Picture

Christoffer Bilsøe on 26 Nov 2021 13:58:28

RE: Connect to Dataflows from Excel's Power Query

Getting close to the final month of 2021 - any updates on the plans for this feature?

Michael Shparber's profile image Profile Picture

John Ellery on 23 Nov 2021 23:11:23

RE: Connect to Dataflows from Excel's Power Query

This would be such a great feature and help drive unified data culture. We have power bi consumers but also lots of adhoc analysis in excel. Connecting those users with the cleansed data sets used to create the centralised reports would be a real win. An update (hopefully with some good news) would be much appreciated.

Michael Shparber's profile image Profile Picture

Robert Bonczyk on 10 Nov 2021 23:05:43

RE: Connect to Dataflows from Excel's Power Query

Any updates on this? We really need this functionality... Thanks.

Michael Shparber's profile image Profile Picture

Sébastien De Bosscher on 03 Nov 2021 10:23:46

RE: Connect to Dataflows from Excel's Power Query

Is there a feature ID, or any update on this functionality?
It is not to be found in Power Platform 2021 release plan wave 2

Michael Shparber's profile image Profile Picture

Richard Hamer on 19 Oct 2021 13:30:07

RE: Connect to Dataflows from Excel's Power Query

It really can't be that difficult, if it's implemented in PowerBI...but it's essential for us.