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
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:
For individual files: Source = excel.Workbook(web.content("Https://Bussinessgroup-my.sharepoint.com/personal/myBossName_com/folderName/otherFolderName/excelFil...), null, true)
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |