query serialization/string conversion

[smpa01]

Is there any progrmatic way to convert any power query  to a string expected by Analysis Service tabular as part of the AS db.

Start from here

let
    Source = Sql.Database("sever", "db", [Query="select 1 as colA"])
in
    Source

required output

    "let",
    "    Source = Sql.Database(\"server\", \"db\", [Query=\"select 1 as colA\"])",
    "in",
    "    Source"

Is there any native method available to do this in analysis-service-tabular library in .net and / python?

@AlexisOlson @ImkeF @GilbertQ @d_gosbell @mthierba 

Thank you in advance.

[lbendlin · Accepted solution]

Why not use the Power Query code as is, as a single string?

[d_gosbell · Accepted solution]

---

@smpa01 wrote:

Is there any native method available to do this in analysis-service-tabular library in .net and / python?

---

If you use the analysis services .net library you just set the expression using the original string you posted It will automatically take care of the json encoding when scripting out to TMSL

[mthierba]

@smpa01   For reference, it's the MPartitionSource.Expression property that will take any valid M code: https://learn.microsoft.com/en-us/dotnet/api/microsoft.analysisservices.tabular.mpartitionsource.exp...
You won't need to worry about the serialization format going this route, as othes hvae pointed out already.

[GilbertQ]

Basically any double quote needs to be escaped with a backslash?

[smpa01]

I have no idea what TOM expects the PQ to be and there is no documentation around it.

[lbendlin · Accepted solution]

Why not use the Power Query code as is, as a single string?