Forum Discussion

joyhackett's avatar
joyhackett
Icon for Helper II rankHelper II
4 years ago
Solved

How to Format a Text String as SQL Query

Hi, I have loaded a table of SQL definitions.   Sample record: schema_name view_name view_definition powerbi view_fact_program_registration SELECT p.club_key, p.location_key, p.service_k...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi joyhackett,

    AFAIK, current power bi does not support formatting T-SQL strings.
    In my opinion, I'd like to suggest your enter 'query editor' to add a custom column to invoke the T-SQL string formatting API that processes and store a formatted string into this custom column.

    Regards,

    Xiaoxin Sheng

joyhackett's avatar
joyhackett
Icon for Helper II rankHelper II
4 years ago

Thank you.

Your solution will only work for the sample row that I provided. There are 100 rows of SQL view definitions.
However, I see what you are doing with the line breaks, so this puts me on a possible path.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi joyhackett,

AFAIK, current power bi does not support formatting T-SQL strings.
In my opinion, I'd like to suggest your enter 'query editor' to add a custom column to invoke the T-SQL string formatting API that processes and store a formatted string into this custom column.

Regards,

Xiaoxin Sheng