Forum Discussion

quirkyASM's avatar
quirkyASM
Regular Visitor
1 year ago

Visual not updating after republishing report.

I have a powerBI report that I update and publish weekly, and have an intermittent issue that I can't seem to figure out. My company is restrictive so I must manually update my data sources in PBI desktop and republish weekly. I generally do this Sunday evenings (US Central time). The problem is that sometimes, like this week, I upload the new report but the PBI service doesn't update the visual. 

 

The visual is simple, I am looking for any applications that have a date populated that correlates to the upcoming weekend. My desktop shows this:

 

As you can see, the latest sched test date is this upcoming weekend, and "thisWeek" has a 1 (which is what I filter for). However, when I upload this to my PBI service, the report doesn't change and I still see last weeks data:

As you can see from the red box, this was updated today. I've cleared my browser cache and had colleagues attempt to pull up the new report, but we all still see the old data. I'm using this data to run a series of powerAutomate flows, so I need to ensure it's updated each sunday.

 

My filters are all correct (triple verified), and I can't find anything that has changed in my semantic model other than refreshing the data. I'm at a loss here. Any ideas? 

 

***UPDATE***
I have deleted the semantic model and report, waited 24 hours, and then republished under a *different* name. Somehow, someway, this report is still showing old data on the powerBI platform. Any other ideas would be appreciated, but I've also raised a ticket with my internal powerBI support group to attack from that angle.

16 Replies

  • quirkyASM  Seems like the Application Name is sorted, can you try sorting the Same fields (Application Name) on both the platforms and check ?

     

    Thanks,

    Jai

    • quirkyASM's avatar
      quirkyASM
      Regular Visitor

      Thanks for the response! No change when I sort on desktop or PBI service.

      • Jai-Rathinavel's avatar
        Jai-Rathinavel
        Icon for Super User rankSuper User

        quirkyASM It might be a bug, have you tried publishing into your personal workspace and checked if there is any data discrepancy ?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi quirkyASM 

     

    Please try the following actions:
    1. After you republish the report, click the Open Report link in the Publish Success dialog box to see if the visual is updated.

    2. View the report in Power BI Service and click the Refresh button in the upper right corner of the report to see if the visual will update.

     

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

     

    • quirkyASM's avatar
      quirkyASM
      Regular Visitor

      Unfortunately, this doesn't help. I've even deleted the model completely from PowerBI service, waited 24 hours, and then republished: same issue. 

      • Anonymous's avatar
        Anonymous
        Not applicable

        my problem was that the data source was an excel that ends with .xlsb changed to .xlsx and now it works fine

  • Anonymous's avatar
    Anonymous
    Not applicable

    I am facing the same. I publish and it shows different numbers of the version I have in desktop.

    • Jai-Rathinavel's avatar
      Jai-Rathinavel
      Icon for Super User rankSuper User

      Anonymous Please check for any page level filters applied by editing the report on service.

      • Anonymous's avatar
        Anonymous
        Not applicable

        There aren't filters applied. I published with _test in the end of the pbix file and it shows the correct numbers. So strange.

    • quirkyASM's avatar
      quirkyASM
      Regular Visitor

      Did you find any way to resolve this?