Pass a Parameter from Power Query to T-SQL and Still Edit Query

Question

Is there any way that I can use the power query parameter inside Tsql and allow to edit the source query?

Answer 1

Use the following formulas

= Sql.Database("server", "db", [Query="SELECT * FROM ABC WHERE Date = [Parameter]"])

= Sql.Database("server", "db", [Query="SELECT * FROM ABC WHERE Date = "&Text.From(Param)])

 let

    Source = Sql.Database("server", "db"),
    dbo_ABC = Source{[Schema="dbo",Item="ABC"]}[Data]
in
    dbo_ABC

Are you new to Power Bi, Look at the Power Bi Training provided by Intellipaat

Check the following youtube link: