Forum Discussion
Helper INoobie question about SQL Query
Helper IHi,
Thank you for your answer,
mussaenda double click on source does nothing in my case
sevenhills i don't have the gear icone near source as usual, i suspect he just copy/pasted his request from another PBix, the "show native request" option is also greyed and can't be choosen
I guess i have to rewrite the request properly or edit it in M but that doesn't look easy compared to an SQL request.
Community SupportHi JohnnyDax
When you use a custom SQL statement when connecting to a database, the "view native query" option will be disabled. This is by design.
Are you using Power BI Desktop? In my test, I can click the gear icon or double-click on Source step to open the data source connection window. You will see that Power BI will add special characters automatically.
If you cannot open this connection window, you can copy that SQL statement outside and paste it into a Text editor, and remove those special characters. Then it will be easier to edit the SQL statement. After you add the column, copy the new statement into a new query to test the connection first. When you ensure the new table is queried correctly, paste its SQL statement string into the old query's Source step. This should be possible.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.