Data Type Mismatch

[Yunus_Miah]

I consistently receive recommendations from stakeholders regarding data types in my reports. They prefer the exported data to mirror the format displayed in the service. For instance, exporting percentage data may result in decimals. Is there a solution available for addressing such issues?

       

[v-jiewu-msft · Accepted solution]

Hi @Yunus_Miah ,

If I understand correctly, the issue is that you exported the data was not the desired result. Please try the following methods and check if they can solve your problem:

1.Ensure that the data type is correctly set in the data model.

2.You can select the column you want to change, try to change the data type in Column tools.

3.Create a measure that converts the decimal to a percentage format.

4.You can also use the following link to learn the data type mismatch.

I get a message about data type mismatch - Microsoft Support

Looking forward to your reply.

Best Regards