Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Number to text in Direct query

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

2 ACCEPTED SOLUTIONS
saileekumawat
Frequent Visitor

As said earlier, you can do this in the at query level 

 

Example.png

View solution in original post

Phil_Seamark
Microsoft Employee
Microsoft Employee

What is your datasource?  If it's SQL you can just modify your query.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

5 REPLIES 5
Phil_Seamark
Microsoft Employee
Microsoft Employee

What is your datasource?  If it's SQL you can just modify your query.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Anonymous
Not applicable

Thanks Sailee and Phil , I guess I have to modify the data in query level as you said.

saileekumawat
Frequent Visitor

As said earlier, you can do this in the at query level 

 

Example.png

Anonymous
Not applicable

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.

MarcelBeug
Community Champion
Community Champion

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.

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!