Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
We are trying to change our folders from local folders to a sharepoint folder.
When I change the source of the files in Power Query, I get the following error.
DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)
Details:
DataSourceKind=SharePoint
DataSourcePath=https://example.sharepoint.com/sites/Folder/Shared/Documents/Orders/UAE
SPRequestGuid=f138f39f-0046-3000-3825-3697055d98f3, f138f39f-104f-3000-0798-886091df15e6, f138f39f-3054-3000-0798-862ce5dab40c
I used this query:
SharePoint.Files(https://example.sharepoint.com/sites/Folder/Shared/Documents/Orders/UAE, [ApiVersion = 15]) in place of the previous File.Contents one.
I have tried using Web.Content, but it would authenticate at all despite entering the correct credentials.
Any idea how to solve this?
Solved! Go to Solution.
Hi @Kareem_Amr_IT ,
It should be an authetication error,I tested here,and no errors:
Go to data source settings and edit the credentials:
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @Kareem_Amr_IT ,
It should be an authetication error,I tested here,and no errors:
Go to data source settings and edit the credentials:
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
With the SharePoint connector, you need to use the site url, not the full url to the folder.
= SharePoint.Files("https://example.sharepoint.com/sites/Folder", [ApiVersion = 15])
From there, you can filter on the FolderPath column to get to your desired folder.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |