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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am having exactly this issue with a share point list rather than a mysql db.

I'm curious as to why there's a 'Solved, Go to solution' on this as there's no solution that I can see in this thread.

There are also multiple threads on this exact issue (as far abck as 2016) with no solutions..

There's a reply in here saying one has to close browser tabs, re-open and then manually click refresh.. This is not a solution either, what's the point of scheduling the refresh if you have to manually click a button!!!!

If anyone actually has a reliable solution for this please update the thread, that would be greatly appreciated.

  • mhsk's avatar
    mhsk
    Icon for Helper II rankHelper II
    7 years ago

    hi try to del and reupload the pbix file to workspace (get data), it worked for me

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Cheers for the response mhsk ,

      I have tested that many times, even making fresh BI reports from scratch to rule out if there's any conflict with the original.

      Same issue occurs.

      I'm using chrome, and a colleague is using firefox, same issue on both browsers. Data source is a share point list.

      In the browser I check the report, confirm successful scheduled refreshes took place overnight.

      However while the sched refreshes were successful, the data has not been updated in the report.

      Refreshing the browser window or manually refreshing the report in the dashboard makes no difference..

      So after this, I check the same report in the desktop application and manually refresh it, this runs and updates the report as expected with the data from the SP list.

      I go back to the dashboard again (in chrome) and click refresh, in the report and not the browser.., and it updates the data :/ 

      I didn't publish the report at any point during this test.

       

      It's my understanding that the scheduled refresh should run the same refresh as the desktop application refresh button does, thereby eliminating the need to manually refresh the report from the dashboard at any point.

      Am I missing something really simple here?

      Any feedback is very welcome.

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

        Morning,

         

        I've been pursuing this with the MS support team since it first became an issue for me in April and after numerous email exchanges and screensharing sessions, they don't appear to be any closer to providing a solution.

         

        They believe that the problem is related to the data connectivity mode and specifically an issue with datasets suppossedly configured as DirectQuery remaining as an Import model behind the scenes.

         

        I'd like to be able to provide more input but I'm becoming increasingly frustrated with the entire affair and the most recent telephone calls with the MS off-shore team have been incredibly discouraging.

         

        I'll update this stream if there is further progress.