Forum Discussion
Data Type changes while importing semantic model to new Dashboard
- 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
Hi abksharma
Just checking in to see if the solution provided worked for you. If it did, consider marking it as accepted so others community members can benefit.
Thank you.