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

    CELINE Celine on 06 Jul 2020 00:00:41

    RE: Connect to Dataflows from Excel's Power Query

    we try to use dataflow as our data lake, data depository, and can be used by either Power BI reports or Excel users.

    Michael Shparber's profile image Profile Picture

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

    RE: Connect to Dataflows from Excel's Power Query

    Need this to be available

    Michael Shparber's profile image Profile Picture

    mboachie on 05 Jul 2020 23:59:22

    RE: Connect to Dataflows from Excel's Power Query

    This please

    Michael Shparber's profile image Profile Picture

    Alisher on 05 Jul 2020 23:59:00

    RE: Connect to Dataflows from Excel's Power Query

    Must to be available

    Michael Shparber's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:58:09

    RE: Connect to Dataflows from Excel's Power Query

    connect to dataflows from both Excel and Excel Power Query would be ideal.

    Michael Shparber's profile image Profile Picture

    Martin G on 05 Jul 2020 23:57:52

    RE: Connect to Dataflows from Excel's Power Query

    Very important to data model prototyping together with Excel users - they are used to seeing data in a certain way.

    This is a half-way house for them to help with validation of data before they get Power BI reports which look and feel very different to what an Excel user is used to.

    Further, it might even enable historical Excel type use-cases on larger datasets. Please, Redmond. Listen up!

    Michael Shparber's profile image Profile Picture

    Swapnil on 05 Jul 2020 23:54:01

    RE: Connect to Dataflows from Excel's Power Query

    Will be great to have it. Speed of Power Query in Excel to process data is so slow when you need to shape the data.

    Michael Shparber's profile image Profile Picture

    Nick Doy on 05 Jul 2020 23:51:54

    RE: Connect to Dataflows from Excel's Power Query

    It would also be useful to Power BI users too.