Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a Numeric column which i want to convert to text using a formula.
But When I try to use FORMAT function it dosent allow me as it dosent support direct query.
Thanks,
Ravi
Solved! Go to Solution.
What is your datasource? If it's SQL you can just modify your query.
What is your datasource? If it's SQL you can just modify your query.
Thanks Sailee and Phil , I guess I have to modify the data in query level as you said.
As said earlier, you can do this in the at query level
Hi ravsha85
If you use direct query (live connection), you can't do any changes (neither in DAX nor in the Query Editor aka Power Query).
The only way to solve this is by editing the column in the source itself.
Looks to me like this should be done in the Query Editor, not in DAX.
In this very short video I illustrate with data from Access: after adjusting data type to text, there is still a Native Query, which makes me think it should also work in Direct Query.
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |