Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I load a dataset from sql server by choosing direct query. When I try to change the data type of a column to Time, a message always popped up like the screen shot shows below. Can anyone help me with this? Thanks ahead.
Solved! Go to Solution.
Changing the data type in direct query mode is not supported through the query editor. However, you should be able to do this after your data is loaded. In your Fields list, select the field you want to change, then select the Data Type in the Modeling tab of the ribbon.
This article (go to the section titled "Ability to change the datatype when connected to Direct Query") and this community post have good screenshots of the process.
Changing the data type in direct query mode is not supported through the query editor. However, you should be able to do this after your data is loaded. In your Fields list, select the field you want to change, then select the Data Type in the Modeling tab of the ribbon.
This article (go to the section titled "Ability to change the datatype when connected to Direct Query") and this community post have good screenshots of the process.
Thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |