getting error when getting excel from sharepoint

[Anonymous]

Hi, 

I have data source from sharepoint (Teams). 

It was working then when I refresh the data, I am getting error in Power BI Desktop.

Then, when I look at power queries, I have got below error. 

Not sure where that comes from. 

Anyone can advise?

[v-jingzhang · Accepted solution]

Hi @Anonymous 

There is an error on the second row in your table. It seems this row doesn't have a file so it produces an error when invoking the custom function. So before this step, insert a step to filter out rows that have null values. This can avoid this error. 

Hope this helps. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

@v-jingzhang 

Thanks. It works now. 

But just wondering how i get that error row... Nothing had changed.