Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

getting error when getting excel from sharepoint

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 er...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

v-jingzhang 

 

Thanks. It works now. 

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