One query output is blank after refresh on a cloud while it works on desktop.

[olegkazanskyi]

Hello,

I have a model of 5 tables. 

1 table stopped showing any values and refreshing on a cloud doesn't help.

When I refresh a model in Desktop everything goes back to normal.

I tried to republish the dataset to another workspace but the problem stays.

Does anyone know where to start digging?

All the credentials are ok and other queries are from the same source. 

[rodrigosan]

Hello, @olegkazanskyi , how are you?
Have you checked the data source credentials in the Power BI service?

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

[olegkazanskyi]

Yes, I just reapplied all the credentials.

No changes after a rerun, unfortunately.

[rodrigosan]

An error message occurs:
Could you send pictures

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

[olegkazanskyi]

No errors 🙂 

The dataset refreshes work ok, but one table is blank.

This is very weird. 

I isolated that one query and I will check how it works separately.