Forum Discussion
On Prem DataGateway connection to On-Prem SQL server and Occive 365 sharepoint site in same report.
I have a report that pulls data from multiple sources. I have PB Pro and have an on prem Gateway with Power BI Pro pulling data from and On Prem SQL server. (MS Project 2013). That gateway worked until I recently added some data to my report that pulls from an Office 365 Sharepoint site (Corporate with the same credentials available for both)
However when I try to add the SharePoint site as a data source I get an authentication error. Everything works great in desktop but when I publish I get the issue. Note I am the owner of the Sahrepoint site on Offcie 365
Is it possible to have multiple data sources like this in one report? And if so how?
Thanks
Unable to connect: We encountered an error while trying to connect to https://SP Site /. Details: "Invalid connection credentials."Hide details
| Activity ID: | f0594afa-3323-248d-8c1a-b9d4274a7627 |
| Request ID: | d364bad1-f046-7d4d-973d-050ce0304029 |
| Cluster URI: | https://wabi-us-north-central-redirect.analysis.windows.net |
| Status code: | 400 |
| Error Code: | DM_GWPipeline_Gateway_InvalidConnectionCredentials |
| Time: | Fri Mar 03 2017 19:12:41 GMT-0700 (Mountain Standard Time) |
| Version: | 13.0.1700.1312 |
| Underlying error code: | -2147467259 |
| Underlying error message: | The credentials provided for the SharePoint source are invalid. (Source at https://SITE.) |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.CredentialError.DataSourceKind: | SharePoint |
| Microsoft.Data.Mashup.CredentialError.DataSourcePath: | https://SITE |
| Microsoft.Data.Mashup.CredentialError.Reason: | AccessForbidden |
Hi bleake,
On-premise data gateway doesn't support SharePoint data source. As the dataset contains both SQL Server and SharePoint data, you an use personal gateway to workaround the issue.
Best Regards,
Qiuyun Yu
3 Replies
v-qiuyu-msftCommunity Support
Hi bleake,
On-premise data gateway doesn't support SharePoint data source. As the dataset contains both SQL Server and SharePoint data, you an use personal gateway to workaround the issue.
Best Regards,
Qiuyun YuThank you. Not the answer I was hoping for but will look to future releases.
