Revision history [back]

You can modify the data type of several columns simultaneously in Power BI by following these steps:

1. Select the table that contains the columns you want to modify.
2. Click on Edit Queries in the Home tab.
3. In the Query Editor window, select the columns you want to modify by clicking on the first column and then holding down Shift and clicking on the last column.
4. Right-click on one of the selected columns and click on Change Type.
5. Choose the data type you want to change the columns to from the drop-down menu.
6. Click on OK.

The selected columns will now be modified to the new data type you selected.