We could not refresh the table resources from connection odata resources data

We could not refresh the table resources from connection odata resources data
InfoPath alternatives for form designing SharePoint

In this post we will discuss how to resolve issue which says We could not refresh the table resources from connection odata resources data. The error looks like below:

We could not refresh the table resources from connection odata resources data
We could not refresh the table resources from connection odata resources data

Also you can check:
– Unable to create or access workbook cache. Excel Services Application is unable to function without a workbook cache Event ID 5226

– Configure On Premise environment for Apps in SharePoint 2016

– SharePoint 2016 List View Auto Indexing Automatic Index Management

Solution:

1. Go to the report which is giving an OData error

2. Open the report in excel

3. Click on data connection properties

4. Click on Authentication setting

5. Use the stored credentials and enter the Power pivot service application ID as showed in below screen

We could not refresh the table resources from connection odata resources data 1
We could not refresh the table resources from connection odata resources data 1

After this the error will not come.

Similar SharePoint 2013 Tutorials


Leave a Reply