Modify Power Query Connection? (SEP 2026 Update)

Hi irisgenx​ ,

Are you in the new Power Query Experience? If you are you can always revert back to the previous one by turning off the option in the preview features and then trying to see if you are able to get the previous pop-up.

Concerning the M Code it's just a question of identifying the correct escape character so if you go to the Advance Editor or use the TMDL editor all of the #(lf) are the codes for a line break so if you on the editor change the code by selecting those value and hitting enter you should be fine.

Example below for SQL database but works in the same way for Snowflake:

Previous

let
    Source = Sql.Database(".", "AdventureWorks2019", [Query = "select SalesOrderID,#(lf)    SalesOrderDetailID,#(lf)    OrderQty,#(lf)    ProductID,#(lf)    SpecialOfferID,#(lf)    UnitPrice,#(lf)    UnitPriceDiscount,#(lf)    LineTotal#(lf)from Sales.SalesOrderDetail"])
in
    Source


After change
let
    Source = Sql.Database(".", "AdventureWorks2019", [Query = "
   select 
          SalesOrderID,
         SalesOrderDetailID,
         OrderQty,
         ProductID,
         SpecialOfferID,
         UnitPrice,
         UnitPriceDiscount,
         LineTotal
from 
         Sales.SalesOrderDetail"])
in
    Source

You can also just get you query from your SQL editor if you already have it and replace the entire code that is on the advance editor just be carefull to keep it inside the quotation marks to be text.

One best practice I picked up is to add a step before the SQL source with my code and then pick it up in the Source step this gives me two main advantages:

• I can check the code at any time because it's a step on power query
• Easy to edit because in advance editor you format has you need

For the same Query this would look like this:

let
    SQLCode = 
    "
    Select 
        SalesOrderID,
        SalesOrderDetailID,
        OrderQty,
        ProductID,
        SpecialOfferID,
        UnitPrice,
        UnitPriceDiscount,
        LineTotal
    From 
        Sales.SalesOrderDetail
    ",
    Source = Sql.Database(".", "AdventureWorks2019", [Query = SQLCode])
in
    Source

TMDL Editor:

 

Regards

Miguel Félix