On Prem DataGateway connection to On-Prem SQL server and Occive 365 sharepoint site in same report.

[bleake]

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

Troubleshoot connection problems

[Seth_C_Bauer · Accepted solution]

@bleake This is a current limitation in the gateways. You can't mix cloud and on-premises in the same dataset. Looks like the idea here has been replied to and the team is currently working on it.

[v-qiuyu-msft · Accepted solution]

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

[bleake]

Thank you. Not the answer I was hoping for but will look to future releases.

[Seth_C_Bauer · Accepted solution]

@bleake This is a current limitation in the gateways. You can't mix cloud and on-premises in the same dataset. Looks like the idea here has been replied to and the team is currently working on it.