Forum Discussion

Frbelotto's avatar
Frbelotto
Frequent Visitor
2 years ago
Solved

Power Bi vs Power Query group by

Help! I own a huge database containing millions of rows of transactions. It does contain many columns with diverse information :     I am working on a power bi dashboard resuming such inform...
Need Help
  • RossEdwards's avatar
    RossEdwards
    2 years ago

    Two methods to achieve this.  In the Source row of your query, click the cog icon and paste your SQL code into the box under "Advanced".

     

    I prefer to use a function called Value.NativeQuery().  Its used like this (advanced editor):

     

    let
    Source = <Your current source row>,
    QueryResult = Value.NativeQuery(Source, "
<SQL GOES HERE>
    ")
in
    QueryResult

     

Frbelotto's avatar
Frbelotto
Frequent Visitor
2 years ago

Thanks!
A quick question. My data source table name is a kind weird.
A must use the table name under "", and the inside "" is breaking the sql text code. On python I solve this by using ' instead of ", but I couldnt do this on the PWBI advanced editor.

 

 

 

RossEdwards's avatar
RossEdwards
Solution Sage
2 years ago

The " character will be considered a special character, all you need to do is use it twice.  Chanage your code to:

FROM DB2I023A. ""ShoppingBB"" t1