Error found when import SharePoint Doc Library to Power BI (Table.ReorderColumns(#"Kept Errors",...)

[rachelbi]

Hi there, i would like to upload a document library in sharepoint into power BI, first of all the URL doesn't allow me to keep in the full link , i.e. https://xyzxyz.sharepoint.com/sites/QA/Authoring%20Documents/Forms/AllItems.aspx  , but only allow to paste : https://xyzxyz.sharepoint.com/sites/QA

Meanwhile, after loading the table, some empty column in the document library are missed in the Table.

Finally, the table cannot be refreshed, error show as below, what should I do? Thanks very much

[VahidDM · Accepted solution]

Hi @rachelbi 

Check these links:
https://community.fabric.microsoft.com/t5/Service/Power-BI-Get-Data-From-SharePoint-List-Library/m-p...

https://www.youtube.com/watch?v=-XE7HEZbQiY

https://www.youtube.com/watch?v=tmITCBCUhYc

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube