Search code examples
powerbi-desktoppower-bi-report-server

Data Type changes while importing semantic model to new Dashboard


measure e.g. [ccm_TotalDeviceCount] Data Type changes while importing semantic model to new Dashboard, A text data type becomes another data type. I tried refreshing the dataset model, can not find any way to change the data type of a measure to TEXT again.

enter image description here

Imported to another Power BI report from Power BI service, this becomes measure [ccm_TotalDevice] becomes General/Number/Int

enter image description here

Thanks


Solution

  • If you want it to be Text then update if(v=blank(), 0,... to if(v=blank(), "0",...