Forum Discussion
Advocate IVinstability in the Power BI auto refresh
Microsoft Employeehi Bitwize_PowerBI,
After looking into the issue, looks like you're running into 2 issues:
- Your dataset size seems to be too big, you mentioned it's taking 45 minutes on desktop, so that might be the reason for the timeout.
- For the token issue, we do not support refreshing the oAuth token. The refresh is failing when the token is expiring, and looks like it's getting refreshed manually when you republish? This is because the personal gateway doesn't automatically refresh the token.
Here's how to work around the 2 issues above:
1- Connect via Direct Query instead of scheduled refresh. You will need an Enterprise Gateway set up instead of the personal Gateway.
2- Seperate the data coming from Cloud from the on-prem sources, as the Enterprise Gateway doesn't allow you to combine online data sources and on-prem. The token issue will be resolved if you have the Cloud resources uncombined with on-prem.
Hope this helps!
Dimah
Advocate IVhello dimazaid,
thank you for looking at the issue.
The dataset size is 300.000 records in total for all tables in the model and takes 10-15 minutes to refresh early in the morning (when it is sheduled). During the day while the internal network is heavily used then it can be 30-45 minutes.
This is within Power BI limits, no ?
The 'web' reference and oauth authentication for the workbook data sources is defined in Power BI service, not the workbook itself. I suppose the Power BI sheduled refresh for the workbook data sources has little to do with the gateway or am I wrong ?
regards,
Dries