Forum Discussion
Sharepoint file as data source results in error row that cannot be removed
Hi,
I am connecting to a Sharepoint file as a data source in Power BI and using Power Query to access the correct file. I can filter the file list to the files I am looking for, but there is always an error row present that I cannot remove.
In the Source step, I have tried specifying APIVersion 14, 15 and also taking the version out altogether. I have also tried clearing my permissions and then resetting them. Removing the errored row doesn't work in any way that I have tried nor does attempting to replace the errors. I have seen some older posts on this issue, but none of them helped me. Any ideas would be appreciated.
Thanks.
9 Replies
Is this actually impacting you? Is there a file behind that error that you need? If so, what sets the file apart from the others? Do you maybe lack permissions?
I need to be able to manipulate the file using Power Query and the error line eventually causes the Power Query to break. I have full access and permissions on the Sharepoint site. Thanks!
Can you add a transformation step "Remove Rows...Remove Errors"?
Hi. Thanks for the reply - I tried several different attempts at removing rows. Removing errored rows, bottom row, etc
Can you post your full M code that shows this break?
It looks like their might be a SharePoint corruption in that library.You could also try changing SharePoint.Files() in the Source line to SharePoint.Contents() if your data is in one folder. Then navigate to that folder. If there is a corruption, it might not be in the folder you need.
You still need to fix any corruption if it exists, but that is a SharePoint admin issue.
Some users of my Excel file have the same error (not me...), and the Table.RemoveRowsWithErrors doesn't work.
I tried on another Sharepoint site and the problem is the same.
I know this an old post, I have the same issue, did you ever get a solution to this?
