Finally, add a measure to the calculated table, to provide the currently selected WhatIf parameter value. This is the measure you’re going to use in Power BI, to pull the WhatIf parameter into your WhatIf scenarios. If you named both your calculated table and calculated table column “MyParam”, you should name this measure “MyParam Value” and use the expression: SELECTEDVALUE(‘MyParam’[MyParam], 50) where 50 is the default value to use, in case multiple values/nothing is selected on the WhatIf slicer.
var server = "te3synapsetest-ondemand.sql.azuresynapse.net";
var database = "AdventureWorksDW";
var applicationId = "e449df3a-957e-40ff-802f-e3fa75e43be1";
var secret = "<your-service-principal-secret-key>";
// Part 1: Create legacy data source
var source = Model.AddDataSource();
source.Provider = "System.Data.OleDb";
source.ConnectionString = string.Format("Provider=MSOLEDBSQL;Data Source={0};Initial Catalog={1};Authentication=ActiveDirectoryServicePrincipal;User ID={2};Password={3}",
server, database, applicationId, secret);
// Part 2: Swap partitions
string mExpression;
foreach(var table in Model.Tables)
{
// Loop through all tables that have at least one M partition, or an M Source Expression:
var partition = table.Partitions.FirstOrDefault() as MPartition;
if (partition != null) mExpression = partition.MExpression;
else if (!string.IsNullOrEmpty(table.SourceExpression)) mExpression = table.SourceExpression;
else continue;
// Extract the schema and name of the source table/view from the M Expression:
string pattern = @"\[Schema=""(?<schema>.*?)"",Item=""(?<item>.*?)""\]";
Match match = Regex.Match(mExpression, pattern);
var sourceObjectName = string.Format("[{0}].[{1}]", match.Groups["schema"], match.Groups["item"]);
// Create a single legacy SQL partition with a "SELECT * FROM <sourceObjectName>" query:
var legacyPartition = table.AddPartition(query: "SELECT * FROM " + sourceObjectName);
legacyPartition.DataSource = source;
// Delete all other partitions:
foreach(var p in table.Partitions.Where(p => p != legacyPartition).ToList()) p.Delete();
}
// Part 3: Perform schema check
SchemaCheck(Model);git add .
git commit -m "Initial commit of code base"
git push