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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
GustavoAguilar
Regular Visitor

I need help! Server error 500 from SharePoint, but why if I have all access to the Onedrive Folder?

I am currently working in a new office, and there are some issues that need to be addressed. Here's the context:

My boss has been working with Power BI alone for quite some time. However, now I will be working with her. She has a Power BI file called "PowerBiFile.pbix" stored in her OneDrive folder, and I have been given permissions to create and update files in that folder. So far, everything is good.

The PowerBiFile.pbix file retrieves data from Excel files located in the same OneDrive folder. I also have permissions to access and modify these Excel files.

To fetch the data in Power BI, we use the following methods:

  1. For individual files: Source = excel.Workbook(web.content("Https://Bussinessgroup-my.sharepoint.com/personal/myBossName_com/folderName/otherFolderName/excelFil...), null, true)

  2. For folders containing multiple files: Source = Sharepoint.files("Https://Bussinessgroup-my.sharepoint.com/personal/myBossName_com)

    OtheStep= Table.SelectRows(#'Source', each Text.Contains([Folder Path], "FolderName"))

When my boss makes changes, everything works perfectly fine, and I am able to see all the information without any issues.

However, when I try to make changes myself, such as duplicating a column, it allows me to do so. But when I attempt to save the changes and refresh the data, an error occurs with the following message:

OLE DB or ODBC error: [DataSource.Error] SharePoint: request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request).

My question is, why does this error occur even though I have permissions in the OneDrive folder? What can I do to work with these files in Power BI? Additionally, what other kinds of permissions should my boss grant me, considering that I already have access to the OneDrive folder?


Captura de pantalla 2023-07-10 134501.pngCaptura de pantalla 2023-07-10 135342.pngCaptura de pantalla 2023-07-10 1356421.png

 

0 REPLIES 0

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.