Scheduled Refresh

[uscoove1]

When I schedule a refresh, it shows as successfully completed. However, when I look at the report all of the visuals are blank. No data appears in the visuals. 

[v-junyant-msft · Accepted solution]

Hi @uscoove1 @Heruy ,

Sorry, after testing by our engineers, this is confirmed to be a Known issue. it is a complicated process to fix, please be patient. I will reply as soon as there is any progress.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Heruy]

Hi, @uscoove1 , & @v-junyant-msft

I managed to resolve the issue, it turns out the problem is with datatypes of Boolean values(True/False), if you have columns that use this datatype in power bi change them from anytext to True/False in power bi desktop & publish, it should resolve the issue.

Here is a video i found https://youtu.be/HJgclrgFnls .

Let me know if it works for you. 

[Heruy]

@uscoove1 brother did you manage to resolve the issue yet? I am also facing same issue, my data source is SharePoint list which is always updated. Here https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data It says there is no need to refresh as power bi by default refreshes data stored in cloud but it doesn't appear to sync anything at all. 
Just like as you mentioned whenever i refresh either manually or scheduled the visuals disappear and caluculated measures show negative values.

[uscoove1]

@HeruyI was not able to resolve the issue. It appears to be a scheduled refresh issue for me. Performing manual refreshes through the Power BI desktop app works, but the scheduled refreshes through Power BI service does not. 

[Heruy]

@uscoove1 Yeah!, for me also it works on desktop PBI but the problem is no one can see this report except me. 
I have some questions,
* How many data sources do you use for your report?( I use two tables from single SharePoint site)
* How big is your Data in Mb?(mine around 60mb when imported in PBI desktop)
* Are you Using any filters on PBI Desktop & Service?
* Did you try republishing Fix for for incase if you tried it?(for me it did not fix at all).
* where is your data source hosted?

Thanks!

[v-junyant-msft]

Hi @uscoove1 ,

Have you solved your problem?
If not, can you tell me what is your datasource and how you set up scheduled refreshes?
Please check if you are using the partition key? Because as far as I know, when there is a partition key conflict or duplicate values in different partitions, there will be no data after refreshing. Other than that, I haven't come across any other situation that would cause a refresh to present empty data for the time being.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@uscoove1 First thing to do is to reset the report. 

[uscoove1]

@Greg_Deckler I reset the report and still am experiencing the same issues. Manual refreshes performed through the Power BI desktop app work and display recent data. Only the scheduled refresh is giving me issues on displaying data.