Expression.Error: We cannot convert the value <ccon>null to type Text.. </ccon>.

[ROG]

Hey all,

Can you please let me know what issue is that?

I can't see any error in PowerQuery on the pbix file.

Many thanks in advance,

Renata

[ibarrau · Accepted solution]

Hi. You can try refreshing the power bi desktop file in order to find the table with the issue. DataTypes usually can skip issues when refreshing a pbix but not on service. At some point there is a value in a column in a table that can't be converted. Check if you can find the table. Then go step by step on that table looking for a change of type to text. That step might be falling. Check the data to understand the value. Then you might need to take a decision on how to proceed depending on the data and your objective.

I hope that helps,

[ROG]

I managed to find the table, and saw there was some new values added to the file, which I delete them and save the file. After that I was able to refresh the dataset in the service.