Skip to main content

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

ANA ARTIME GUZMAN on 06 Oct 2021 17:36:46

RE: Connect to Dataflows from Excel's Power Query

This feature is planned for the second half of 2021 so I hope we are on schedule!

Michael Shparber's profile image Profile Picture

Anthony Sloan on 16 Sep 2021 07:13:10

RE: Connect to Dataflows from Excel's Power Query

Keep us posted! Looking forward to this!

Michael Shparber's profile image Profile Picture

Patryk Iwanicki on 13 Sep 2021 08:42:58

RE: Connect to Dataflows from Excel's Power Query

I am really looking forward to having this feature. It would greatly simplify our ETL processes. Now we need to connect to some source files over and over again and copy-paste lots of PQ code...

Michael Shparber's profile image Profile Picture

Miguel Ulloa on 31 Aug 2021 23:38:17

RE: Connect to Dataflows from Excel's Power Query

Really looking forward for this to be implemented.

Michael Shparber's profile image Profile Picture

Alan Stanford on 16 Aug 2021 13:54:19

RE: Connect to Dataflows from Excel's Power Query

Is this still planning to be implemented 2021 2H or has this been pushed back?

Michael Shparber's profile image Profile Picture

Christoffer Bilsøe on 27 Jul 2021 18:59:06

RE: Connect to Dataflows from Excel's Power Query

So the Power Platform 2021 release plan wave 2 is out ( https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/) and unfortunately I don’t see this feature being mentioned anywhere... 
is there any update on this?
 

Michael Shparber's profile image Profile Picture

Jesse Sor on 12 Jul 2021 23:59:32

RE: Connect to Dataflows from Excel's Power Query

Any update on this? Would be great to have this or an alternative if possible, big stressor right now trying to convert a pivot table to a normal table which is not working as planned for solutioning.

Happy to discuss internally as well if there is preview that I can use.

Michael Shparber's profile image Profile Picture

Hugo Michel on 18 Jun 2021 12:25:47

RE: Connect to Dataflows from Excel's Power Query

This feature is soooo important and will definitely make dataflows more attractive to end users

Michael Shparber's profile image Profile Picture

Ryan Montgomery on 28 May 2021 21:15:38

RE: Connect to Dataflows from Excel's Power Query

Just want to say: thank you for responding and updating the status on this item from Closed to Planned, and providing the additional context that it is planned for release this year. This should make a lot of people happy. I can't wait to shift my Excel imports from Datasets to Dataflows...getting rid of an additional layer that never needed to be there. Cheers!

Michael Shparber's profile image Profile Picture

Srdan Drljaca on 30 Apr 2021 09:04:04

RE: Connect to Dataflows from Excel's Power Query

We need this feature, otherwise DataFlows will never reach wider application.