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

Rob Rathsack on 12 Sep 2022 15:21:07

RE: Connect to Dataflows from Excel's Power Query

What Version was this released?

Michael Shparber's profile image Profile Picture

Stephanie Tinker on 09 Sep 2022 21:55:45

RE: Connect to Dataflows from Excel's Power Query

This would be such a WIN to connect dataflows from excel's power query. Excel is a mainstream tool and the ability to link with dataflows will create an efficient solution. MS WHEN?

Michael Shparber's profile image Profile Picture

Rob Rathsack on 09 Sep 2022 16:20:36

RE: Connect to Dataflows from Excel's Power Query

How is this not done yet? If MS wanted to be a full solution package it needs this. Getting more people to use more services together

Michael Shparber's profile image Profile Picture

Tom Smith on 21 Jul 2022 08:59:14

RE: Connect to Dataflows from Excel's Power Query

Looks like we are over a year with no update. Can you let us know please.

Michael Shparber's profile image Profile Picture

Selim Targay on 10 Jun 2022 17:19:08

RE: Connect to Dataflows from Excel's Power Query

Any updates? It was supposed to be in 2021. This seems like a slam-dunk easy thing, why wouldn't a MS data source (dataflows) not be supported in a MS product?It's very annoying and not good practice to create a Dataset linking to a Dataflow just to source data into Excel since only Datasets are supported.

Michael Shparber's profile image Profile Picture

Robert Hawlor on 04 May 2022 06:37:25

RE: Connect to Dataflows from Excel's Power Query

Does the OP know when this will be implemented? 2021 was 5 months ago and still nothing. I am desperate to get to the PF data in excel.

Michael Shparber's profile image Profile Picture

Robert Rivas on 26 Apr 2022 17:05:33

RE: Connect to Dataflows from Excel's Power Query

But it seems no query folding (yet?) :-(

Michael Shparber's profile image Profile Picture

Robert Rivas on 18 Apr 2022 21:16:01

RE: Connect to Dataflows from Excel's Power Query

Works for me!! Never thought this day would arrive...LOL

Michael Shparber's profile image Profile Picture

Andy McCourt on 07 Apr 2022 08:10:40

RE: Connect to Dataflows from Excel's Power Query

It could be that it hasn't rolled out to all versions yet - I'm working on version:Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bit 

Michael Shparber's profile image Profile Picture

Nathaniel Lim on 06 Apr 2022 21:07:36

RE: Connect to Dataflows from Excel's Power Query

Hey tried the method as stated in previous post::"In excel, do Get Data -> Other Sources -> Blank Query. The first line of your query needs to be: =PowerPlatform.Dataflows(null)"Getting expression error:Expression.Error: The name 'PowerPlatform.Dataflows' wasn't recognized. Make sure it's spelled correctly.Note: This is testing on Excel 365Anyone else successful in connecting? If so how so?