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

    Fritz Koszik on 06 Jul 2020 00:04:27

    RE: Connect to Dataflows from Excel's Power Query

    This would really help to automate many things. Complex Power Queries can run scheduled in the cloud once instead of 100 times on individual Excels.

    Michael Shparber's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:04:05

    RE: Connect to Dataflows from Excel's Power Query

    essential for prototyping - please give me this for xmas.

    Michael Shparber's profile image Profile Picture

    Faruq on 06 Jul 2020 00:03:50

    RE: Connect to Dataflows from Excel's Power Query

    This is a MUST have guys!

    Michael Shparber's profile image Profile Picture

    Megan Steele on 06 Jul 2020 00:03:30

    RE: Connect to Dataflows from Excel's Power Query

    Yes please!

    Michael Shparber's profile image Profile Picture

    Richard on 06 Jul 2020 00:03:14

    RE: Connect to Dataflows from Excel's Power Query

    yes yes yes!

    Michael Shparber's profile image Profile Picture

    Zach van Dorp on 06 Jul 2020 00:02:33

    RE: Connect to Dataflows from Excel's Power Query

    Very keen to get access to this too! Would solve a bunch of problems.

    Michael Shparber's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:01:43

    RE: Connect to Dataflows from Excel's Power Query

    Yes please - the are numerous use cases where this would be really useful

    Michael Shparber's profile image Profile Picture

    Selim Targay on 06 Jul 2020 00:01:24

    RE: Connect to Dataflows from Excel's Power Query

    This connector should have been available as soon as MS launched dataflows. It's only half-implemented with access to the dataflow not available in Excel.

    Michael Shparber's profile image Profile Picture

    Andriano on 06 Jul 2020 00:01:21

    RE: Connect to Dataflows from Excel's Power Query

    Ideally in Excel's Power Query should be all data sources like in latest Power BI release Power Platform category with Power BI Dataflow, Power BI Dataset and Common Data Services in it. And even better - drivers to connect from external applications (for example from Python/R scripts) to all Power Platform sources.

    Michael Shparber's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:00:56

    RE: Connect to Dataflows from Excel's Power Query

    This would be good idea and it would help complete the whole vision/functionality of Dataflows and drive adoption.