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...
I would recommend setting the data type in the Query Editor, NOT in the data view:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
That will ensure that data type is set properly upon refresh.
If you're still having trouble with the refresh or there are errors in the Query Editor, please share your M code from Advanced Editor if able