Forum Discussion
Manual dataset refresh stops working sometimes
Resident RockstarHi Han12345 ,
I have a little confused about your scenario.
Do you have this refresh error in Power BI or in Excel? If there is any more detail error message?
If it is convenient, could you share the screenshot of your error message?
Do you have this issue for other dataset or only this specific dataset?
Best Regards,
Cherry
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
zanottilucaHelper II
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.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
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