cancel
Showing results for 
Search instead for 
Did you mean: 

Report based on sharepoint URL gives error while Schedule refresh

We have built PBI report on Shapoint URL and it is working fine in Power BI Desktop. When publishing to PBI Service and trying to do schedule refresh, under datasource credentials\Edit credentials, it gives only Anonymous and windows as authentication options. When trying to select windows and privacy level none or organizational, it gives below error(screenshot1). When I tried to get the logs based on this activity id, Logs says as below(Logs:). Also when search the forums for this issue, I found that I also dont see "Connect Directly" option under Gateway Connections (screenshot2)and I dont get option for OAuth under authentication. Thank you so much for your help.

Logs:

DM.EnterpriseGateway Information: 0 : 2019-09-04T21:08:49.9165193Z DM.EnterpriseGateway 538658f5-6f0a-4ab5-b73f-1a0fd88d3469 31cf3696-cedf-ad92-c8ff-be576746d1df MGPP a91f86d5-d752-47e7-aa3d-1a8ad6760912 B83A3E6E [DataMovement.PipeLine.GatewayDataAccess] SingleSignOnInformation isnull
DM.EnterpriseGateway Information: 0 : 2019-09-04T21:08:49.9165193Z DM.EnterpriseGateway 538658f5-6f0a-4ab5-b73f-1a0fd88d3469 31cf3696-cedf-ad92-c8ff-be576746d1df MGPP a91f86d5-d752-47e7-aa3d-1a8ad6760912 E41368EA [DataMovement.PipeLine.GatewayDataAccess] Upn is

Screenshot1:

PBIERROR.PNG

 

Screenshot2:

PBIERROR2.PNG

 

Thank you! Not sure if this is right place to submit the issue.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @snehadixit

 

Which connector do you use in Power BI desktop to get data? 

 

Based on my test, when I use SharePoint online list connector in Power BI desktop, after publishing the report to service, it's able to choose OAuth2 authentication type then in Edit Credentials section. I would suggest you test again. 

 

q2.PNG

 

Best Regards,
Qiuyun Yu