Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI Service refresh issue

When I run refresh now, my report refreshes in about 1 minute.  When a scheduled refresh runs, it takes about 15 minutes.  What the heck is going on?
Need Help
  • GilbertQ's avatar
    GilbertQ
    7 years ago

    Hi Anonymous 

     

    No worries I like to sometimes to make people think a little differently on the current issue.

     

    In order to log a support ticket, after you search for an issue, if nothing pops up you can then get the option to create a support ticket as shown below.

     

GilbertQ's avatar
GilbertQ
Super User
7 years ago
Hi there

It could be many things that are causing it to do that. Could be the Power BI Service, it could be your Gateway server, it could be your data source.

Is there any reason if it takes 15minutes is an issue?
Anonymous's avatar
Anonymous
Not applicable
7 years ago

My report gets refreshed 8 times a day per user request to have near real time data. So I don't want it to take 15 minutes to refresh.  I don't understand why the "refresh now" process would be any faster or slower than the scheduled refresh process.  They are both are using the same Gateway server and the same data sources.  It makes no sense.  How do I report this issue to Microsoft?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Here is refresh history from yesterday:

     

    Scheduled8/14/2019, 6:32:20 AM8/14/2019, 6:45:18 AMCompleted 
     Scheduled8/13/2019, 5:02:18 PM8/13/2019, 5:16:29 PMCompleted 
     On demand8/13/2019, 4:38:52 PM8/13/2019, 4:39:19 PMCompleted 
     Scheduled8/13/2019, 4:02:21 PM8/13/2019, 4:16:14 PMCompleted 
     Scheduled8/13/2019, 3:02:24 PM8/13/2019, 3:15:13 PMCompleted 
     Scheduled8/13/2019, 2:03:08 PM8/13/2019, 2:18:21 PMCompleted
    • GilbertQ's avatar
      GilbertQ
      Super User
      7 years ago
      Hi there

      If it is only being refreshed 8 times a day once every hour, then if it takes 1 min or 15 mins is there any real difference for the report consumers?

      You can log a support ticket with Microsoft if you want to get more details.
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        You make a valid point that it doesn't really impact the users whether the refresh takes 1 min or 15 min.  I'm just trying ot understand why the supposedly same process takes so much longer to run as a scheduled job compared to an on demand job.  You stated that I can "log a support ticket with Microsoft if you want to get more details".  How do I accomplish this?  When I go to https://powerbi.microsoft.com/en-us/support/ and click on Report an Issue it takes me to a "Suggest an Idea" page.  I want to report an issue to Microsoft, not suggest an idea.