Power BI Service Scheduled Refresh Removes data

[Anonymous]

I have a report that uses Azure SQL db and an Excel file stored in Sharepoint Online.  The data is fine in Desktop.  I publish to Service and it still looks great.  If I schedule a refresh it removes data from the report.  However, if I manually refresh the report from the service it is fine.  

So I go and download the .pbix that has the missing data.  With this pbix I refresh it from Desktop and it brings the data back in.  I publish this same report and the data is still missing.  

Again, I download this report and this time I delete the report and dataset from Service.  I also install the latest gateway even though everything is in the cloud.  I refresh from Desktop, it brings back the missing data, I publish again.  The data is there in Service.  I refresh manually from Service and it is still good.  I schedule refresh and after the refresh, the data is gone again.  I feel something is broken in the scheduled refresh of Service.

[v-lili6-msft]

hi  @Anonymous 

strange behavious, try to clear browser cache and then try it again.

and i couldn't reproduce this issue, I would suggest you submit a support  ticket to get further help from power bi support team.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031?advanced=false&collapse_discussion=true&q=Scroll%20down%20and%20click%20%22CREATE%20SUPPORT%20TICKET%22.&search_type=thread

Regards,

Lin