Quick summary
Changing a data type in Power BI is done through the Power Query Editor, where you can select any column and reassign its type in just a few clicks. This ensures your data is correctly formatted for accurate calculations, visualizations, and reporting.
Steps
- Click on the visual table in your Power BI report canvas.
- Click Transform Data to open the Power Query Editor.
- In the table preview, find the column whose data type you want to change.
- Click the small data type icon in the column header and select the desired data type.
- After you're done, click Close & Apply to save your changes back to the report.
