Forum Discussion

Bitwize_PowerBI's avatar
Bitwize_PowerBI
Advocate IV
10 years ago

instability in the Power BI auto refresh

Hello,   I’m having some stability issues with a scheduled refresh from the Power BI service. From time to time the auto-refresh fails while nothing in my setup changed.   My setup is the follow...
Need Help
dimazaid's avatar
dimazaid
Microsoft Employee
10 years ago

hi Bitwize_PowerBI,
We're looking into this issue. Thanks for reporting, I'll reply here again once we have a solution.

Thanks!
Dimah

dimazaid's avatar
dimazaid
Microsoft Employee
10 years ago

hi 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

  • Bitwize_PowerBI's avatar
    Bitwize_PowerBI
    Advocate IV
    10 years ago

    hello 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