Forum Discussion

Ry5's avatar
Ry5
Icon for Helper I rankHelper I
4 years ago
Solved

Format a field to Title Case when using Direct Query

Hello, I need to set a field to Title Case, which is easily done in Transform Data > Transform Tab > Format > Capitalise Each Word However I'm getting an error that this can't be done with Direc...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Ry5 ,

     

    No, Direct Query mode does not support this complex query foldring. The only way to solve the problem is from your database side

     

    The power bi get data form SQL Database is using query foldring to change the query to sql statement and send it to SQLDB, then SQLDB return the data to power bi. 

    Query foldring only support simple transform data like sum(), rename().This is for better performance performance and unnecessary errors. For more details you can refer these links.

    Query folding - Power Query | Microsoft Docs

    Using DirectQuery in Power BI - Power BI | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.