Forum Discussion
Expression.Error: We cannot convert the value <ccon>null to type Text.. </ccon>
Hi, I have set up a scheduled refresh in Power Service and I am getting the below error message. My dashboard is connected a SharePoint Page. Data source error: Expression.Error: We cannot ...
Hi sburke7848 ,
Based on the error message, there have 'null' values in your data source which could not be converted to text type.
'null' value and blank value are different, refer: https://www.excelguru.ca/blog/2018/10/04/nuthin-aint-nuthin-in-power-query/
Please check your data type which includes 'null' value and replace values before you convert it to text type.
You can refer to the similar posts that may be helpful to you:
Expression.Error: We cannot convert the value <cco... - Microsoft Power BI Community
Expression.Error: We cannot convert the value null... - Microsoft Power BI Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.