Error message dissapears immediately after error occures when refreshing data on Power BI Desktop

[pollkatan2027]

Hi,

I I have a critical issue and need some help. When I refresh data on Power BI desktop, something error occurs and it said, "Loading blocked by failures with other queries." so I would like to check what table has the error and tried to scroll the message, but couldn't, because the error message disappeared soon after it showed up.

What should I try to solve this problem?

In addition, I tried refresh the data from Power BI service, and it succeeded. 

Could you give me suggestions of what I should try to?

[Anonymous]

Hi @pollkatan2027 

This issue should be caused by something wrong in any data source refreshing. 

How did you check your data source? Here I suggest you to refresh each table in Power Query Editor and check which one will return error in refreshing. Then do some troubleshooting on the error. 

As far as I know, many times these issue may be caused by invalid or incorrect data source credential.

Best Regards,
Community Support Team _ Ailsa Tao

[pollkatan2027]

Hi @Anonymous 

Thanks for your reply. I will check data source by refreshing each table in Power Query Editor. Could I confirm how to do it? I thought the step is this. 1.Open Power Query Editor 2. select a table 3.refresh preview 

Am I correct?

Thanks again,