Forum Discussion
smpa01
Community Champion
Community Championquery 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"...
d_gosbell
Super User
Super User
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
Advocate I
Advocate Ismpa01 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.