Forum Discussion

abksharma's avatar
abksharma
Helper II
1 year ago
Solved

Data Type changes while importing semantic model to new Dashboard

measure e.g. [ccm_TotalDevice] 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 wa...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi  @abksharma 
    Thank you for engaging with the Microsoft Fabric Community.
    In addtion reply to rajendraongole1 


    The below solution would be to explicitly convert the measure to a text data type using the FORMAT() function in DAX before importing it into the new Power BI report or dashboard.

    Modify your measure as follows:

    ccm_TotalDevice_Text = FORMAT([ccm_TotalDevice], "0")

     
    The measure is always treated as text, regardless of how it's imported or refreshed in the Power BI Service.
    By explicitly formatting it as text, you avoid any issues with the data type being automatically changed to General/Number/Int when imported into another report.

     

    If the above information helps you, please give us a Kudos and marked the reply as a solution.

    Thanks,
    Cheri Srikanth

     

v-csrikanth's avatar
v-csrikanth
Community Support
1 year ago

Hi abksharma 

I wanted to check if you had a chance to try the suggested solution of using the FORMAT() function to explicitly convert the measure to a text data type.

Has it helped resolve the issue you were facing with the data type changing when importing the measure into another report?
Please let us know if you need any further assistance.

Looking forward to your update.

If the above information helps you, please give us a Kudos and marked the reply as a solution.

Thanks,
Cheri Srikanth