Forum Discussion
query serialization/string conversion
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.
Why not use the Power Query code as is, as a single string?
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
5 Replies
Why not use the Power Query code as is, as a single string?
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
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.expression?view=analysisservices-dotnet
You won't need to worry about the serialization format going this route, as othes hvae pointed out already.
Basically any double quote needs to be escaped with a backslash?
I have no idea what TOM expects the PQ to be and there is no documentation around it.
