Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Not able to edit and add to Power BI Dataflow

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

ApiResponseError: ApiRequest error with status 0
at p.handleErrorEvent (https://asia.prod.powerquery.microsoft.com/MashupEditor/scripts/p.o.a.0405076208ba3af15881.bundle.js...)
at XMLHttpRequest.<anonymous> (https://asia.prod.powerquery.microsoft.com/MashupEditor/scripts/p.o.a.0405076208ba3af15881.bundle.js...)

 

This only happened since last week. I was able to do editing or add tables to the dataflow previously.

Any other suggestion/solution?

mikeLiu_0-1687136776032.png

 

Update: Already tried to update the gateway to latest version but still no clue.

mikeLiu_1-1687146132485.png

 

 

Status: Needs Info
Comments
Anonymous
Not applicable

HI @mikeLiu 

What is the related data source ? Is your data source now in a functioning state ? Is there currently a problem with this particular dataflow or is there a problem with all of them ?

 

Best Regards,
Community Support Team _ Ailsa Tao

mikeLiu
Regular Visitor

Hi Ailsa Tao @Anonymous ,

 

The data source is Microsoft SQL on-premise link to the gateway. 

Yes, it is a functioning state in the live production server.

Some of the dataflows with larger data amounts / more tables are having the same problem.

It is workable previously but having this problem for the last 2 weeks.

 

Regards

Mike