Forum Discussion
Sharepoint Scheduled Refresh Error
Hi,
I have an on-premise gateway set up for our Power BI Reports, there are 2 data sources for the gateway, one is an SQL Server database and the other is an Excel Spreadsheet uploaded to Sharepoint. When using Power BI Desktop both data sources refresh without any issue but once they have been published to the Power BI service with a scheduled refresh set up I am getting the below error;
Underlying error code: -2147467259
Underlying error message: 'Implementation' isn't a valid SharePoint option. Valid options are:
ApiVersion
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 84081e6f-14bd-4bf1-bb9f-6d0132ff144f
Request ID: 8a3de68d-4b15-ec49-a3ac-3077f058b05b
Time: 2020-11-18 15:18:40Z
I've done a bit of searching but have been unable to find how to fix,
TIA
Paul
Hi Anonymous
You accesse on-premises (SQL Server database) and cloud sources (Sharepoint.) in the same source query
Please check whether you do merging or appending data from on-premises and cloud sources.
If you do, you need to do two options as below to configure a data gateway to support merging or appending data from on-premises and cloud sources:
- Add a data source definition for the cloud source to the data gateway in addition to the on-premises data sources.
- Enable the checkbox Allow user's cloud data sources to refresh through this gateway cluster.
You can refer to this blog for more details: Refresh Data
And I found an issue like yours, I hope it could help you.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous
You accesse on-premises (SQL Server database) and cloud sources (Sharepoint.) in the same source query
Please check whether you do merging or appending data from on-premises and cloud sources.
If you do, you need to do two options as below to configure a data gateway to support merging or appending data from on-premises and cloud sources:
- Add a data source definition for the cloud source to the data gateway in addition to the on-premises data sources.
- Enable the checkbox Allow user's cloud data sources to refresh through this gateway cluster.
You can refer to this blog for more details: Refresh Data
And I found an issue like yours, I hope it could help you.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.