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 error. 

Not sure where that comes from. 

 

 

Anyone can advise?

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.

2 Replies

  • 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.