Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

How to add SharePoint data source to On-Premise(Enterprise) gateway using Microsoft Account

I have used PBI Desktop to connect to a Sharepoint file and published it to PBI Service.

On PBI Service I am able to establish credentials using Oauth2.

But when I try to add the connection to my On-Premise (Enterprise) gateway, there is no option to use Oauth2 credentials so I can't add the connection.  

 

What am I supposed to do?

 

I know I can connect the Sharepoint datasource directly to PBI service, but that doesn't work because there's some modeling I need to do with PBI Desktop.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @angus-tebukuro ,

 

Is the dataset only connecting to SharePoint online data source? Is it is, as SharePoint online is not an on-premises data source, it doesn't need to create a SharePoint online source in Manage gateways section. 

 

If there is another on-premise data source the dataset connecting to, you can add on-premises data sources in Manage gateways section, then follow this document to configure the dataset to use the gateway. 

 

Best Regards,
Qiuyun Yu