Forum Discussion
after data refresh all data types turned into Text
Hi, I took over a dashboard (.pbix) file from a collaborator. First thing I wanted to do is refresh the data (through an Athena ODBC connection) using the refresh button in my Power BI desktop envi...
Anonymous , You need to figure out why data type has changed.
Open Data Transformation and Edit Query mode. Change Data type there. In case there is some error look for the error row and correct it.
refer to this for that https://www.youtube.com/watch?v=9-Lag0VOiTs
AllisonKennedy and amitchandak Thanks for the quick replies!
After refresh I can change data types without any errors occuring (but there several tables and many columns:))! Actually another collaborator can refresh without errors. Can it be that there are Settings that introduce this behaviour? I checked File> Options > Local File > Data Load with and without automatic Data Type detection but both same error.
- Anonymous are you and collaborator both using the same version of the report and the same version of power bi desktop?
Can you please confirm that you are changing data types using M in Power Query, not just in the Data View? Using M is a more reliable way to change the data type and will force the conversion to number even if there is text, but will return an error.
