Skip to main content

Power BI

Completed

Connect to Dataflows from Excel's Power Query

Vote (38) Share
Hanneke P's profile image

Hanneke P on 19 Apr 2021 07:59:26

Please allow the connection to Dataflows' entities from Excel's Power Query.
There are many usecases.

Administrator

Released

Comments (5)
Hanneke P's profile image Profile Picture

Hugo Michel on 19 May 2021 08:39:14

RE: Connect to Dataflows from Excel's Power Query

How comes this is not implemented yet ??? In february microsoft said this feature would be released in March update... Then wasn't... Now I see that the idea shows "complete" (https://ideas.powerbi.com/ideas/idea/?ideaid=c472a0fa-e161-4fb5-8384-b9f63d282d68) when it is absolutely not the case.

Not professional... the whole community is waiting for this must have feature

Hanneke P's profile image Profile Picture

David Molina on 07 May 2021 10:26:48

RE: Connect to Dataflows from Excel's Power Query

This is a must since most data receivers of curated datasets are not familiar with Power BI and more with Excel.

Hanneke P's profile image Profile Picture

Daniel H on 04 May 2021 13:28:00

RE: Connect to Dataflows from Excel's Power Query

I'd like to understand why the previous post says it was completed. Is it done and just not rolled out? Is there an ETA? Or was the admin misunderstanding the ask?

Hanneke P's profile image Profile Picture

Joris Van poucke on 03 May 2021 07:33:47

RE: Connect to Dataflows from Excel's Power Query

I totally agree with this. We should be able to connect from Excel to dataflows, to give our end-users a single source to get their validated data.

Hanneke P's profile image Profile Picture

N G on 19 Apr 2021 15:28:30

RE: Connect to Dataflows from Excel's Power Query

Dataflows seem like a great way to centrally distribute curated content to citizen developers. But sadly, we won't be using them for that or anything else since there's no Excel integration. Despite the popularity of Power BI, most analyses still end up in Excel.

The related idea (https://ideas.powerbi.com/ideas/idea/?ideaid=c472a0fa-e161-4fb5-8384-b9f63d282d68) shows complete, but I don't think this is the case.