Forum Discussion

Han12345's avatar
Han12345
Frequent Visitor
7 years ago

Manual dataset refresh stops working sometimes

Hi,   I have a published dataset which is connected to an Excel file (via 'Analyze in Excel') and needs to be manually refreshed regularly. A scheduled refresh works fine and a manual refresh also ...
Need Help
Han12345's avatar
Han12345
Frequent Visitor
7 years ago

Hi Cherry,

 

The refresh error happens in the Power BI Report Service, when clicking the manual refresh button. 

 

And there is no error message, that is the weird part. It says "Preparing to refresh" just likt it always does, but then nothing happens. When you click it again, again "Preparting to refresh" shows up and still nothing happens. Then suddenly after a few hours it refreshes twice (or more times if you clicked it more times). 

 

As far as I know there problem is only present for one dataset, but I am not sure, since this is the only dataset that is (and needs to be) manually refreshed regularly.  

 

Regards,

Han

 

 

 

zanottiluca's avatar
zanottiluca
Helper II
7 years ago
Hi there, this happened to me as well today. The only difference is that we have not excel as datasources but mix of csv and oracle dataset. There is any solution? Is the gateway involved? I have also check the status but seems the only "awareness" is regarding a gateway issue for the march verzion. Funny thing is that we have an older version of the gatway but still we encounter this problem.
  • Han12345's avatar
    Han12345
    Frequent Visitor
    7 years ago

    I haven't found a solution yet... It still works perfectly sometimes and doesn't at other times. I have updated the data gateway (personal mode) to the latest version, but this doesn't help. 

     

    By the way, I am not only using Excel as a datasource. It is a combination of Excel files and an ODBC connection to a PostgresSQL database. 

     

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi Han12345 ,

      Please check if the Refresh history is successful after your manually refresh?

      If it is scuccessful, I'm afraid that your 'd better create a support ticket to get the further help if you have the Pro license.

      Best  Regards,

      Cherry