cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yna4ever
New Member

Schedule Refresh Error

I have been encountering issues in scheduled refresh...

 

My data are from SharePoint and the error appears to be Sharepoint related.

 

The errors include:

 

SharePoint: Request failed: "Sharepoint link"/_api/contextinfo Table: XXX

Unable to connect to the remote server. The exception was raised by the IDataReader interface. Table: XXX

 

  • When online refresh (both scheduled and on-demand) fails, offline refresh in Power BI desktop would succeed with the same dataset.
  • The table that the error code refers would vary everyday.
  • Interestingly, scheduled refresh works well in weekends but always fail on weekdays.

 

I want to know the reason that lead to the refresh failure. One reason I am considering is the dataset size. (around 400 excel files on SharePoint, each ~100kb)

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Schedule Refresh Error

Hi @yna4ever ,

 

There are several points you may considerate:

 

1.Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

 

2.If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .

 

Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

3.Ensure that you've added one or more data sources of your dataset to the gateway, as described in Add a data source.

 

4.Please make sure the gateway is online, and try to upgrade the gateway to latest version.

 

5.Please set schedule refresh for different datasets at different times, make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities. Also we suggest that you first disable all refreshes on all capacities. Then slowly enable the refreshes one by one. Make sure refreshes are staggered apart (e.g. 1 hour apart), and that no more than max concurrent refreshes happen at overlapping time periods.

 

6.Power BI Pro or Power BI Free supports uploading Power BI Desktop (.PBIX) files that are up to 1 GB in size.

Power BI Premium supports uploading Power BI Desktop (.PBIX) files that are up to 10 GB in size.

If you need to upload PBIX file that is larger than 10 GB, consider to move data from your source to SQL Server, Oracle or SSAS, then use DirectQuery/Live connection.

 

You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

Re: Schedule Refresh Error

Hi @yna4ever ,

 

There are several points you may considerate:

 

1.Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

 

2.If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .

 

Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

3.Ensure that you've added one or more data sources of your dataset to the gateway, as described in Add a data source.

 

4.Please make sure the gateway is online, and try to upgrade the gateway to latest version.

 

5.Please set schedule refresh for different datasets at different times, make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities. Also we suggest that you first disable all refreshes on all capacities. Then slowly enable the refreshes one by one. Make sure refreshes are staggered apart (e.g. 1 hour apart), and that no more than max concurrent refreshes happen at overlapping time periods.

 

6.Power BI Pro or Power BI Free supports uploading Power BI Desktop (.PBIX) files that are up to 1 GB in size.

Power BI Premium supports uploading Power BI Desktop (.PBIX) files that are up to 10 GB in size.

If you need to upload PBIX file that is larger than 10 GB, consider to move data from your source to SQL Server, Oracle or SSAS, then use DirectQuery/Live connection.

 

You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

ignaciops
Frequent Visitor

Re: Schedule Refresh Error

Dear all,

 

I am facing the same error, but all my datasources are pointing to sharepoint online files and folder. Initially i though it was this, but the refreshing data is only taking less than 30 minutes. The only difference is that i have several reports pointing to the same files folder... Could it be this one the problem?

 

Thanks in advance

Helpful resources

Announcements
June 2020 Community Challenge: Can You Solve These?

June 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.