Forum Discussion

equerystrian's avatar
equerystrian
Icon for Advocate I rankAdvocate I
4 years ago

Dataflows coming to Excel Power Query Soon-ish?

Through the magic of preview features seen on YouTube, I was thrilled to see Wyn Hopkins present that Power Query in Excel will (soon?) be able to connect to Power BI Dataflows. What I can’t quite fi...
Dataflow
Need Help
collinq's avatar
collinq
Icon for Super User rankSuper User
4 years ago

Hi equerystrian ,

 

According to AJMcCourt 

"

It hasn't been properly rolled out yet, but I've figured out how it can be done (and it's really easy!). Not sure if this has been fully rolled out inside excel yet, I'm using excel 365 and it's working for me.

 

In excel, do Get Data -> Other Sources -> Blank Query.

 

The first line of your query needs to be:

 

=PowerPlatform.Dataflows(null)

"

  • equerystrian's avatar
    equerystrian
    Icon for Advocate I rankAdvocate I
    4 years ago

    Thanks, I wish that would work but it must require at least some of the preview updates to be in place. That function is not recognized when I attempt to run it in my Excel that's tied to the semi-annual enterprise updates.