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.