When getting data from SharePoint, can't sign in - "a security policy is preventing access"

[Anonymous]

Hi there,

I'm trying to connect an excel on Sharepoint to PowerBI. 

I have tried both Get - "web" and "Sharepoint foler" and not working.

I tried to "Sign in" with "Organization account". (See below)

But it gives error below:

Sorry, a security policy is preventing access

An organization security policy requiring token protection is preventing this application from accessing the resource. You may be able to use a different application.

I have no trouble to connect excel on my local machine. I have full permission to the sharepoint site. I only experence this difficulty when connecting to the Sharepoint. 

Could you help? Any directions and suggestions are appriciated.  

Thank you! 

 

 

[Anonymous · Accepted solution]

I was able to partially solve this, howeaver I'm not 100% sure which step works. I pasted my excess here for others who might face the same issue.

Here are couple workaround I tried:

1. Play with the file Sensitivity Lable, make sure both sharepoint file and powerbi report has the same sensitivity level.

2. Use Web Power BI page, Import Excel File: Select "New" and then choose "Semantic model". Then import semantic model to the report.

Hope this help. 

[v-nmadadi-msft]

Hi @Anonymous,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Ritaf1983]

Hi @Anonymous 

As the error message says, this is likely due to an organization-level security policy that enforces token protection. These kinds of restrictions are typically managed by your IT or security team and may block Power BI (or other applications) from accessing SharePoint resources, depending on how access policies are defined in Azure AD or SharePoint.

 Recommended steps:

Reach out to your IT team to check whether there are Conditional Access or Information Protection policies in place that block this kind of access.

In some organizations, only certain approved apps can connect to SharePoint – even with valid credentials.

If you're not sure where the block is coming from, I suggest:

Posting this issue in the SharePoint Tech Community or Microsoft forums, or

Opening a support ticket with Microsoft to investigate the security policy that's being enforced.

Link to shaperoint forum :
https://techcommunity.microsoft.com/category/content_management/discussions/sharepoint_general

Opening ticket :

https://techcommunity.microsoft.com/discussions/sharepoint_general/open-support-ticket-for-sharepoint/4222138

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous]

Hi Rita, I tried to use powerBI Web version to connect my file on sharepoint. I was able to sign in and review the table data, but after I clicked "load data", it gives this error message. Do you have any insight about it? 

Underlying Error: {"code":"ExternalServiceUserFailed","pbi.error":{"code":"ExternalServiceUserFailed","parameters":{},"details":[{"code":"ModelingServiceError_Reason","detail":{"type":1,"value":"Streaming Pqo evaluation failed"}},{"code":"ModelingServiceError_Location","detail":{"type":1,"value":"Streaming Pqo Evaluation"}},{"code":"ModelingServiceError_ExceptionType","detail":{"type":1,"value":"GatewayPipelineWrapperException"}},{"code":"ModelingServiceError_Message","detail":{"type":1,"value":"Credentials are required to connect to the Web source. (Source at https://sampleSite.myExcel.xlsx.)"}}],"exceptionCulprit":1}}
Activity ID: 010c5e33-d90d-4157-9b65-381ace3c0957
Correlation ID: ae7d556f-80bd-32aa-caa7-619b063c1c5f
Request ID: e466b721-8fc0-e140-1dcd-62d084be3920
Status code: 400
Time: Tue Apr 01 2025 09:51:01 GMT-0700 (Pacific Daylight Time)
Service version: 13.0.25684.25
Client version: 2504.1.23614-train
Cluster URI: https://df-msit-scus-redirect.analysis.windows.net/

[Anonymous]

I'm contacting IT regarding this issue. Will close this after I hear back from them. 

Thank you Rita!