Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
    MarcelBeug
    Community Champion
    9 years ago

    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.

  • saileekumawat's avatar
    saileekumawat
    Advocate I
    9 years ago

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

     

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

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