Forum Discussion

PeteDTG's avatar
PeteDTG
Frequent Visitor
4 years ago
Solved

Data Source Refreshing Fine - data disappears from visuals

Hello,   I'm having an issue with a few reports lately.  The reports refresh with no error on a schedule, but after the refresh the data completely disappears from any of the visualizations contain...
refresh issue
  • PeteDTG's avatar
    PeteDTG
    4 years ago

    After many attempts, with nothing working at all (changing data formats, boolean logic, etc.), I set the Power BI datasets to refresh in Azure after my pipelines had successfully completed.  I run my pipelines every 30 minutes and refresh my Power BI datasets every 30 minutes as well. 

     

    I believe my pipelines were not completing fully, before the Power BI dataset refresh, causing only partial data to be imported.  

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi PeteDTG 

 

I think this has something to do with cache.

I would suggest deleting the scheduled refresh and the report.

Resave the report but with a different name and a new scheduled refresh with a different name.

See how you go with that.

Happy to help 🙂

  • PeteDTG's avatar
    PeteDTG
    Frequent Visitor
    4 years ago

    Anonymous thanks for the response I do appreciate it.  

     

    I have tried deleting the report and dataset from service and republishing already.  Although I never tried changing the name of the report.  I will try deleteing, renaming the report, and schedule the refresh again.  I'll let you know if that has any impact. 

     

    Thanks,

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Good luck. I have had the same problem and deleting and republishing does not work as I think it had something to do with the cache and I don't know how to clear it.

      Changing to a new name eg Dashboard Q4 --> Dashboard - Q4

      tricks it to thinking it is a different report. Even though it does schedult to refresh, it kind of caches the data.

      Good luck