Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
CSJ123
Frequent Visitor

Nulls removed from column but scheduled refresh fails on PowerBi Online

Hi

I have several sharepoint online lists connected to PowerBi. One of the lists has a choice column with blanks in it. When I expand this list column in PowerBi desktop - query, the null values throw errors. I can remove the errors without issue, refresh data in desktop, and publish the updated report... However, once the report and dataset are published in PowerBi online, the scheduled refresh fails due to the null values not being able to be converted to text. As the sharepoint list I am using has literally thousands of null values in this column, I am not sure how to tackle this issue, to enable auto/scheduled refresh. If the data can be refreshed in desktop, why does the online data refresh fail? Any workarounds as doing a manual refresh in Desktop and republishing every day, isn't ideal.

 

"Expression.Error: We cannot convert the value [ccon]null[/ccon] to type Text.. [/ccon]."

Thanks 

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. The refreshes don't work in the same way for Service and Desktop. Service is way more restricted, so if it can't refresh you still have errors in the Desktop even though you can refresh it there. You might want to keep error for the columns, re order by a column or look for null values, etc. Do whatever you can to find the missing error or where you are converting to Text. If you refresh the whole Desktop without any warning, then you could refresh on Service, but the warnings can be failures at service.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
j_ocean
Helper V
Helper V

Replace the nulls with a text placeholder in your Power Query.

ibarrau
Super User
Super User

Hi. The refreshes don't work in the same way for Service and Desktop. Service is way more restricted, so if it can't refresh you still have errors in the Desktop even though you can refresh it there. You might want to keep error for the columns, re order by a column or look for null values, etc. Do whatever you can to find the missing error or where you are converting to Text. If you refresh the whole Desktop without any warning, then you could refresh on Service, but the warnings can be failures at service.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors