Dataflow into Excel PowerQuery

[Anonymous]

Hi All

Has anyone managed a workaround to this that actually works or know when this will be implemented by MS?

I have seen a few people saying you can do this via excel online using Blank query and =PowerPlatform.Dataflows(null) - I have tried this and just get an error.

Any workarounds or knowledge on when this will be available would be greatly appreciated.

thanks guys 🙂

[v-chenwuz-msft · Accepted solution]

Hi  @Anonymous , 

I doubt it is possible to do so. PowerBI.Dataflows(null) is only supported in these products:

Power BI (Datasets)
Power BI (Dataflows)
Power Apps (Dataflows)
Dynamics 365 Customer Insights (Dataflows)

Power Query Dataflow connector - Power Query | Microsoft Docs

However, you can try create a dataset in power bi online by connect the dataflow via Power BI Desktop. And then connect the dataset in power bi service by excel online.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.