Forum Discussion

Roytjoo's avatar
Roytjoo
Icon for Advocate II rankAdvocate II
9 years ago

CSV file from Sharepoint Online

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.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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