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 convert the value <ccon>null to type Text.. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. |
1 Reply
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.
