cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to refresh or connect to an Excel File in a SharePoint folder

Hi,

 

On Power BI Desktop I have been trying to refresh or connect an Excel file in a SharePoint folder. The file was created by someone else and posted to a SharePoint with a url that has --https://mycompanyname.sharepoint.com/sites/Workspace. I have been made an Owner of the page. When I refresh the PBI report, I get the message "Access to the resource is forbidden"(See Below).

accessisforbidden.PNG

I grabbed the link to the SharePoint folder and I am able to access it via a web browser.

 

So my next step was to change my authentication. It was set to Windows. From there I tried Anonymous and Microsoft Account. Anonymous did not work. After I hit Microsoft Account, I used my company O365 account email, I got the following blank window:

 

blank.PNG

 

I have the most current version of Power BI on my machine and another person who has the report on their local is able to refresh it without any problem. I do not know what version of PBI the other person is working with.

 

This seems like really basic functionality that should work with Power BI and I have been really frustrated by the answers given so far. Usually it is somebody just posting a link to directions on how to connect to a SharePoint folder. I know how to do it. When I do it, it does not work. Please do not send me a link to this : https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/ 

 

-Joe

Status: Accepted
Comments
Visitor

I have the same issue, when i try to update a report with many data Connections (a report that i have been working 6 months ago) or when i try to create a new connection in a new report, all the authentication is with an organizational account. the connection doesn´t since the last week .Imagen 1.png

Moderator

Hi all, 

 

The same issue already reported internally: CRI 111124505. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

Moderator
Status changed to: Accepted
 
Frequent Visitor

Не работает.jpg


@jdp215 wrote:

Hi,

 

On Power BI Desktop I have been trying to refresh or connect an Excel file in a SharePoint folder. The file was created by someone else and posted to a SharePoint with a url that has --https://mycompanyname.sharepoint.com/sites/Workspace. I have been made an Owner of the page. When I refresh the PBI report, I get the message "Access to the resource is forbidden"(See Below).

accessisforbidden.PNG

I grabbed the link to the SharePoint folder and I am able to access it via a web browser.

 

So my next step was to change my authentication. It was set to Windows. From there I tried Anonymous and Microsoft Account. Anonymous did not work. After I hit Microsoft Account, I used my company O365 account email, I got the following blank window:

 

blank.PNG

 

I have the most current version of Power BI on my machine and another person who has the report on their local is able to refresh it without any problem. I do not know what version of PBI the other person is working with.

 

This seems like really basic functionality that should work with Power BI and I have been really frustrated by the answers given so far. Usually it is somebody just posting a link to directions on how to connect to a SharePoint folder. I know how to do it. When I do it, it does not work. Please do not send me a link to this : https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/ 

 

-Joe


Тоже не работает загрузка с onedrive business!!! 

Moderator

Hi all, 

 

Please test again to see if the issue is gone. 

 

Best Regards,
Qiuyun Yu