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.
In my dataset I have a column named "Äccount No." this is text and I changed its type to "text". However, when it appears in my query, it shows a date format. I selected "ÄBC" on query column of power bi but still showing different format from what I have ion my dataset. I am confused! Please help me.
The snapshots from query and excel attached.
Solved! Go to Solution.
Hi,
In the Query Editor, there should be a Change Type step (the second Step i guess). Delete that step. Alternativey, in the Advanced Editor, change the data type of this field from type date to type text.
Hope this helps.
Hi,
In the Query Editor, there should be a Change Type step (the second Step i guess). Delete that step. Alternativey, in the Advanced Editor, change the data type of this field from type date to type text.
Hope this helps.
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |