Forum Discussion

spinachbisque's avatar
spinachbisque
New Member
7 years ago
Solved

Scheduled Refresh Succeeds but Data Won't Update

I have built a Power BI report that queries data from a SQL Server database at my organization. I've uploaded the report to Power BI online and set up a scheduled refresh with the help of our IT staf...
  • Anonymous's avatar
    Anonymous
    7 years ago

    spinachbisque How quickly are you checking the report after the dataset has said it has refreshed? The Dataset, Report and dashboard are seperate objects and are not all immediately refreshed after the dataset. It is in order. If the dataset refreshes, it is likely it will be 10-15 before the report, and then the Dashboard. You can also initiate a refresh in the report after the dataset.

    If you know, and or tried the above, then this sounds like a bug or issue that you should raise in a support ticket or the issues page.

ims20180411kjb's avatar
ims20180411kjb
Icon for Advocate I rankAdvocate I
7 years ago

Hi, I'm also experiencing the same issue.

 

I have two reports in a workspace and their associated datasets both use the same gateway to two different databases in the same SQL Server instance.

 

The datasets for both reports indicate that they have refreshed at the scheduled time. However, whilst one report shows the refreshed data, the second report does not, even if I click the report refresh button.

 

Similarly, clicking the 'Refresh now' action within the Datasets list has no effect.

 

I have tried republishing the report, which works for that day but then fails to refresh the following day. I have deleted the reports and associated datasets and even deleted the Gateway but to date, none of these attempts have succeeded in resolving the issue.

 

Any input or advice would be appreciated.

 

Karl

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This exact same problem is happening to me as well. It started around 5/1. I never get any refresh errors, but I don't see the most up-to-date data on my reports.

 

The only way to solve this has been to refresh from Power BI Desktop and reupload, which is very time consuming.

  • ims20180411kjb's avatar
    ims20180411kjb
    Icon for Advocate I rankAdvocate I
    7 years ago

    Hi jonathanf,

     

    I've opened a support call to deal with this and will keep you updated. However, at this point they seem to be stumped.

     

    Cheers

     

    Karl

    • Spoerryj's avatar
      Spoerryj
      Regular Visitor
      4 years ago

      It's been a while but we'd appreciate an update on what came of this.

  • rlhane's avatar
    rlhane
    Regular Visitor
    7 years ago

    EXACTLY the same issue here.  The refresh history claims that the data was updated successfully again and again, yet the report does not show any recent data, even after a manual report refresh.  I have to open the report in the desktop app, refresh it and republish it to bring up to date data to the cloud report.  What powerbi.com is doing with all that beautiful data it's supposedly gathering for us is a mystery. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I've semi solved the issue, by not doing any data manipulation in PowerBI at all - and only using one data source :S

      • ahcspbi's avatar
        ahcspbi
        Frequent Visitor
        7 years ago

        We are experiencing the same problem - out of curiosity (as I saw some people mentioning above), does everyone kinda have the same situation happening here?

         

        1. Multiple databases

        2. Direct Query Datasets based on Views

         

        Appears to be a pattern. The above is precisely what's up with our dataset.

    • Ruchita's avatar
      Ruchita
      Icon for Helper I rankHelper I
      2 years ago

       

      Have you found the solution to this? I am facing the same problem.