Refresh in Service - incorrect data with Azure SQL Database

[Anonymous]

Hello All,

I have a Azure SQL Database as my datasource.  

When I refresh the data in Service, I get inaccurate old stale data.  When I refresh this same data in desktop, the data is accurate.

The only way for me to get around this issue is to refresh the data in desktop and then publish to Service.

However, if refresh this same report later in the day in Serivce, the data is completely inaccurate again.

My desktop version is Version: 2.59.5135.781 64-bit (June 2018).

Since my datasource is in the cloud I am not using a gateway.

What can be done to correct this issue?  

[v-qiuyu-msft]

Hi  @Anonymous,

I'm not able to reproduce the issue on my side. Does the issue happen before? 

Please update the Power BI desktop to July version then republish the report to test again. 

Best Regards,
Qiuyun Yu