Forum Discussion

dc7669's avatar
dc7669
Resolver II
2 years ago
Solved

PowerBI Report refresh issue

Hi all,   I have a PowerBI Report that is scheduled to refresh once a day.  In the last few days, there are issues with the update that it could not complete.    So, I added another update time ...
Dataflow
  • dc7669's avatar
    dc7669
    2 years ago

    FYI, the data refresh for my Power BI refresh was successful twice in a row now using OnPremise data connection to connect to the cloud database where the data resides.  

    So, I guess On-Premise data connection is less prone to failure. 

     

    dc7669

dc7669's avatar
dc7669
Resolver II
2 years ago

Hi Anand24 vanessafvg ,

 

This is the Refresh History.  

I set it up to run at 1am and 130am.  

Last successful scheduled run was 130am on May 14. 

On May 15, both 1am and 130am failed.  

I "on Demand" started it again at 355am and then at 922am and then 928am.  All failed. 

May 14, 1am/130am failure.

 

355am/ 922am / 928am failure.

For updating from PowerBI Desktop, I think we can see those in  "One Drive" tab.  It was successful at 927am

 

The Data for this report came from two cloud databases.

I have connections set up to reach them via Cloud AND OnPremise data gateway. 

At the beginning, I was using OnPremise data gateway.

Then, had occassional failure.  So, I thought may be using Cloud connection would help, and I changed.

Occassional failure continued.  

 

"Combined Permits" contains data from both databases. 

pro_FY2012_FR is a data table from one of the cloud database.  This Cloud database is a cloud Microsoft SQL database.  I am not too sure what the other cloud database is (Azure/Amazon or something else....).

 

Any ideas/suggestions on why the refresh keep failing and how to make them run successfully? 

 

Thanks.

 

dc7669