Unexpected error when trying to open power query on Dataflow

[davi]

I am unable to edit or add any tables to one of my dataflows. The following message appears:

ApiResponseError: Unexpected Error
at d.handleLoadEvent (https://us.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.a22c49213e78ab68edfc.bundle.js:2:3...)
at XMLHttpRequest.<anonymous> (https://us.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.a22c49213e78ab68edfc.bundle.js:2:3...)

All connections are to Sharepoint lists. The dataflow refreshes and I can access it normally on PBI desktop, but I can't edit any of its queries.

[davi · Accepted solution]

Actually my error was different than the ones of the those hyperlinks. We had to open a ticket to Microsoft and they worked on it and solved the problem.

[v-xiaotang]

Hi @davi 

Thanks for reaching out to us.

please check if this 2 posts help,

Solved: We encountered an unexpected error - Power BI Serv... - Microsoft Power BI Community

Unexpected error while using Power query editor - Microsoft Community

Best Regards,

Community Support Team _Tang

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