cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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. 

 

dogbural_0-1675314302382.png

 

Anyone can advise?

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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. 

vjingzhang_0-1675410645901.png

Hope this helps. 

 

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

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

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. 

vjingzhang_0-1675410645901.png

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
Not applicable

@v-jingzhang 

 

Thanks. It works now. 

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors