Access is Forbidden Web Link

[Anonymous]

I am trying to bring in a link to an Excel .csv stored in a Sharepoint folder. I go to Get Data-Web then paste the destination link, ending in the file extension ".csv" (removing the ?web=1). But i end up seeing "Unable to connect, We encountered an error while trying to connect. Details: "Access to the resource is forbidden.", giving me the options to Retry, Edit or Cancel. What can i do to resolve this?

[Anonymous]

@v-chenwuz-msft That was not it, it was a permissions issue.

@amitchandak Yes, it was a credentials issue. I did not check the Global permissions. I did not sign in through organizational account for the Web.

[v-chenwuz-msft]

Hi @Anonymous ,

You can directly copy the path in the detail of the file on sharepoint.

For more details you can refer this link.

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@Anonymous , This is because of the URL link or the credentials.  One of these is wrong.

Similar

https://community.powerbi.com/t5/Desktop/Access-to-resource-is-forbidden/m-p/654917

https://community.powerbi.com/t5/Desktop/Access-to-resource-is-forbidden-web-csv/m-p/1465366