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_bonczyk]

Any updates on this? We really need this functionality... Thanks.

[John_Ellery]

This would be such a great feature and help drive unified data culture. We have power bi consumers but also lots of adhoc analysis in excel. Connecting those users with the cleansed data sets used to create the centralised reports would be a real win. An update (hopefully with some good news) would be much appreciated.

[christoffer_bil]

Getting close to the final month of 2021 - any updates on the plans for this feature?

[Andrew_Mccourt]

Are there any updates to this? Can't see it on the 2021 Release Wave 2 schedule?

[ricardo_ferraro]

Hi Community, nice to meet you here. I would like to remind that second half of 2021 ends in like 22 days. Will this planning be attended in this time window ? Best regards.

[Andrew_Mccourt]

Seems like the administrator who changed this to Planned has disappeared? I can't see it on the release wave anymore.

[ricardo_ferraro]

Hi community, today I started to see a "From Power BI" / Get Data in Excel´s menu. But as far as I could check, the list of data sources shown after the connection contains only "datasets". Is this what you are seeing on your side ? If so, does this means that we still doesn´t have a connector to Power BI´s dataflows ? Best.

[Eric_Harvey]

Only datasets are available on my side as well unfortunately. I don't see any information about this feature anywhere in Microsoft's documentation/roadmap beside this thread.

[anatoliy]

https://www.thebiccountant.com/2021/01/24/workaround-to-connect-to-power-bi-dataflows-from-power-query-in-excel/ posted 2021-01-24

[mgrosse]

Hello! Second half 2021 is sort of kind of over... any updates? 🙂

Keep it up!