Forum Discussion

uscoove1's avatar
uscoove1
Regular Visitor
2 years ago
Solved

Scheduled Refresh

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. 

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Heruy
      Frequent Visitor

      Hi, uscoove1 , & Anonymous

      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. 

    • uscoove1's avatar
      uscoove1
      Regular Visitor

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • Heruy's avatar
    Heruy
    Frequent Visitor

    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's avatar
      uscoove1
      Regular Visitor

      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's avatar
        Heruy
        Frequent Visitor

        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!