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

    Hugo MICHEL on 17 Jan 2021 14:54:03

    RE: Connect to Dataflows from Excel's Power Query

    Hi so I don't see the feature even though it is market as completed. Can you advise ?

    Michael Shparber's profile image Profile Picture

    Maikel de Bekker on 07 Jan 2021 14:59:48

    RE: Connect to Dataflows from Excel's Power Query

    I can't find anywhere how to connect a PBI Dataflow with Power Query in Excel as it says this idea is completed. where can I find this?

    Michael Shparber's profile image Profile Picture

    Mark Paradis on 08 Dec 2020 20:16:48

    RE: Connect to Dataflows from Excel's Power Query

    I see this was completed as of today, will there be a rollout of O365 for Excel to recognize the connector?

    Michael Shparber's profile image Profile Picture

    Bard Cloete on 01 Oct 2020 09:08:01

    RE: Connect to Dataflows from Excel's Power Query

    I concur

    Michael Shparber's profile image Profile Picture

    Ralph West on 21 Sep 2020 17:55:50

    RE: Connect to Dataflows from Excel's Power Query

    Please add

    Michael Shparber's profile image Profile Picture

    Shiva Kumar NT on 04 Sep 2020 14:19:28

    RE: Connect to Dataflows from Excel's Power Query

    This would be a great feature

    Michael Shparber's profile image Profile Picture

    Gavin Doyle on 04 Sep 2020 04:23:03

    RE: Connect to Dataflows from Excel's Power Query

    This would provide a great opportunity for single source of truth data for both Power BI and excel users.

    Michael Shparber's profile image Profile Picture

    James Daily on 25 Aug 2020 00:31:09

    RE: Connect to Dataflows from Excel's Power Query

    This idea represents the second half of the migration story for using Dataflows instead of Excel Power Query for data preparation. There is documentation here on how to migrate the data preparation to the service:
    https://docs.microsoft.com/en-us/power-query/dataflows/how-to-migrate-queries-from-power-query-desktop-to-dataflows

    Unfortunately the documentation only shows you how to move away from Excel for the queries, but not how to consume the results when you still need them in Excel. A lot of heavy lifting or standardization can be done in the service, but a lot of users still need to consume the final result as Excel content.

    A native connector would be ideal for keeping things simple for Excel users. Maybe it could work like the Dynamics 365 (current environment) when targeting the built in (transparent) ADLS gen2 capacity backing the workspaces. Anything that can abstract away the complexities of the underlying common data model folders would make it easier for the typical Excel business user to consume the final result.

    Michael Shparber's profile image Profile Picture

    Maarten Heymans on 06 Aug 2020 11:32:48

    RE: Connect to Dataflows from Excel's Power Query

    we would like to see this happen

    Michael Shparber's profile image Profile Picture

    Peter Wilson on 28 Jul 2020 08:15:58

    RE: Connect to Dataflows from Excel's Power Query

    This would be a great feature