Connect to Dataflows from Excel's Power Query

[mshparber5]

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

[Robert_Rivas1]

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

[Robert_Rivas1]

But it seems no query folding (yet?) 😞

[rob_hawlor]

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.

[STargay]

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.

[Tom_Smith]

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

[robert_rathsack]

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

[Stephanie_Tinke]

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?

[nishalit]

Released.

[robert_rathsack]

What Version was this released?