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

    Hanneke P on 19 Apr 2021 08:00:27

    RE: Connect to Dataflows from Excel's Power Query

    https://ideas.powerbi.com/ideas/idea/?ideaid=7759e028-e5a0-eb11-89ee-501ac50a7898

    I doubled the idea, because this one says it is resolved, but it clearly is not. So please vote!

    Michael Shparber's profile image Profile Picture

    Frederic Frans on 13 Apr 2021 10:58:55

    RE: Connect to Dataflows from Excel's Power Query

    Where is this feature if completed? I can't find it anywhere in Excel???

    Michael Shparber's profile image Profile Picture

    Romain S on 07 Apr 2021 12:34:59

    RE: Connect to Dataflows from Excel's Power Query

    Not available and disappeared from Roadmap.
    Any comment from Microsoft teams?

    Michael Shparber's profile image Profile Picture

    Harold Anderson on 06 Apr 2021 22:39:31

    RE: Connect to Dataflows from Excel's Power Query

    In no way does this look to be available

    Michael Shparber's profile image Profile Picture

    Adam Dunworth on 01 Apr 2021 12:08:22

    RE: Connect to Dataflows from Excel's Power Query

    In no way does this look to be available

    Michael Shparber's profile image Profile Picture

    Eugene Akimov on 26 Mar 2021 22:03:10

    RE: Connect to Dataflows from Excel's Power Query

    It says completed but no words in roadmap /release plan, is it dropped ?

    Michael Shparber's profile image Profile Picture

    Paulo Calado on 08 Mar 2021 08:36:39

    RE: Connect to Dataflows from Excel's Power Query

    I'd love to know in what way was this feature delivered?
    I've simply copied the Powerquery script from a dataflow connecting to another dataflow, which works fine in the PowerBi Webservice thus should also work in the built-in PowerQuery in Excel...unfortunately i had no luck. It simply can't recognize the Dataflow as a source.
    Looking forward to further instructions....anyone? Admin?

    Michael Shparber's profile image Profile Picture

    Riley Hale on 19 Feb 2021 14:58:17

    RE: Connect to Dataflows from Excel's Power Query

    This was marked as completed in December, but so far I don't see any sign of this. I'm running the Beta version of Office Pro Plus and there is no sign of this feature anywhere. Can someone from Microsoft please explain why this is marked as complete?

    Michael Shparber's profile image Profile Picture

    N G on 17 Feb 2021 14:08:30

    RE: Connect to Dataflows from Excel's Power Query

    Can you explain how this feature is used? I was expecting a Dataflow connector in Excel similar to the experience in Power BI, but I don't see one.

    Is this available in a preview version of Excel?

    Michael Shparber's profile image Profile Picture

    Matthew Hurst on 16 Feb 2021 10:25:13

    RE: Connect to Dataflows from Excel's Power Query

    I still cannot see this connector as an option within Excel. Can you please advise.