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.
Dear Power BI guru's
Currently I try to retrieve data from a csv file that is stored on a teamsite in Sharepoint Online. What I currently found is that I have to use the base URI /sites/name and de SharePoint Folder connector. I manually changed the APIVersion from 15 to 14, this will result in a list of a lot of files. I try to filter (with Power Query) to find the single file, and this still works. If I expand the Content column, It starts evaluating the query and ends in an error:
I get the following error:
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)
Details:
DataSourceKind=SharePoint
Could this be caused by a Sharepoint Setting, I currently have no clue why it is not working for me, and for other is does.
Hi @Roytjoo,
I follow your steps but the query works without the issue. Can you share some detailed information about your issue? It will be help for troubleshooting.
Full query:
let Source = SharePoint.Files("https://xxxxx.sharepoint.com/sites/xxxxx", [ApiVersion = 14]), #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".csv")), #"Expanded Attributes" = Table.ExpandRecordColumn(#"Filtered Rows", "Attributes", {"Content Type", "Kind", "Size", "ContentTypeID", "Name", "Title", "SharedWithDetails", "Description", "DocumentIDValue", "DocumentID", "Id", "ContentType", "Created", "CreatedById", "Modified", "ModifiedById", "CopySource", "ApprovalStatus", "Path", "CheckedOutToId", "VirusStatus", "IsCurrentVersion", "Owshiddenversion", "Version", "SharedWith", "CreatedBy", "ModifiedBy", "CheckedOutTo"}, {"Attributes.Content Type", "Attributes.Kind", "Attributes.Size", "Attributes.ContentTypeID", "Attributes.Name", "Attributes.Title", "Attributes.SharedWithDetails", "Attributes.Description", "Attributes.DocumentIDValue", "Attributes.DocumentID", "Attributes.Id", "Attributes.ContentType", "Attributes.Created", "Attributes.CreatedById", "Attributes.Modified", "Attributes.ModifiedById", "Attributes.CopySource", "Attributes.ApprovalStatus", "Attributes.Path", "Attributes.CheckedOutToId", "Attributes.VirusStatus", "Attributes.IsCurrentVersion", "Attributes.Owshiddenversion", "Attributes.Version", "Attributes.SharedWith", "Attributes.CreatedBy", "Attributes.ModifiedBy", "Attributes.CheckedOutTo"}) in #"Expanded Attributes"
Regards,
Xiaoxin Sheng
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |