Forum Discussion

kkr_nok's avatar
kkr_nok
Frequent Visitor
6 years ago

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 alw...
Need Help
lbendlin's avatar
lbendlin
Super User
6 years ago

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?

kkr_nok's avatar
kkr_nok
Frequent Visitor
6 years ago

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!

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    Can you add a transformation step "Remove Rows...Remove Errors"?