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

    Rob Rathsack on 12 Sep 2022 15:21:07

    RE: Connect to Dataflows from Excel's Power Query

    What Version was this released?

    Michael Shparber's profile image Profile Picture

    Stephanie Tinker on 09 Sep 2022 21:55:45

    RE: Connect to Dataflows from Excel's Power Query

    This would be such a WIN to connect dataflows from excel's power query. Excel is a mainstream tool and the ability to link with dataflows will create an efficient solution. MS WHEN?

    Michael Shparber's profile image Profile Picture

    Rob Rathsack on 09 Sep 2022 16:20:36

    RE: Connect to Dataflows from Excel's Power Query

    How is this not done yet? If MS wanted to be a full solution package it needs this. Getting more people to use more services together

    Michael Shparber's profile image Profile Picture

    Tom Smith on 21 Jul 2022 08:59:14

    RE: Connect to Dataflows from Excel's Power Query

    Looks like we are over a year with no update. Can you let us know please.

    Michael Shparber's profile image Profile Picture

    Selim Targay on 10 Jun 2022 17:19:08

    RE: Connect to Dataflows from Excel's Power Query

    Any updates? It was supposed to be in 2021. This seems like a slam-dunk easy thing, why wouldn't a MS data source (dataflows) not be supported in a MS product?It's very annoying and not good practice to create a Dataset linking to a Dataflow just to source data into Excel since only Datasets are supported.

    Michael Shparber's profile image Profile Picture

    Robert Hawlor on 04 May 2022 06:37:25

    RE: Connect to Dataflows from Excel's Power Query

    Does the OP know when this will be implemented? 2021 was 5 months ago and still nothing. I am desperate to get to the PF data in excel.

    Michael Shparber's profile image Profile Picture

    Robert Rivas on 26 Apr 2022 17:05:33

    RE: Connect to Dataflows from Excel's Power Query

    But it seems no query folding (yet?) :-(

    Michael Shparber's profile image Profile Picture

    Robert Rivas on 18 Apr 2022 21:16:01

    RE: Connect to Dataflows from Excel's Power Query

    Works for me!! Never thought this day would arrive...LOL

    Michael Shparber's profile image Profile Picture

    Andy McCourt on 07 Apr 2022 08:10:40

    RE: Connect to Dataflows from Excel's Power Query

    It could be that it hasn't rolled out to all versions yet - I'm working on version:Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bit 

    Michael Shparber's profile image Profile Picture

    Nathaniel Lim on 06 Apr 2022 21:07:36

    RE: Connect to Dataflows from Excel's Power Query

    Hey tried the method as stated in previous post::"In excel, do Get Data -> Other Sources -> Blank Query. The first line of your query needs to be: =PowerPlatform.Dataflows(null)"Getting expression error:Expression.Error: The name 'PowerPlatform.Dataflows' wasn't recognized. Make sure it's spelled correctly.Note: This is testing on Excel 365Anyone else successful in connecting? If so how so?