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

    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.