{"id":101585,"date":"2024-02-28T23:56:42","date_gmt":"2024-02-28T23:56:42","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=101585"},"modified":"2024-09-03T20:15:16","modified_gmt":"2024-09-03T20:15:16","slug":"customizing-kusto-data-explorer-connections-in-deployment-pipeline","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/customizing-kusto-data-explorer-connections-in-deployment-pipeline\/","title":{"rendered":"Customizing Kusto (Data Explorer) Connections in Deployment pipeline"},"content":{"rendered":"

When organizing our SDLC<\/strong> (Software Development Lifecycle) in Power BI\/Fabric<\/strong>, we use Deployment Pipeline<\/strong>s and create rules to change connection configurations every time we promote an object from one environment (dev for example) to another (test, for example). Kusto connections, on the other hand, are not so simple.<\/p>\n

You can check more about Deployment Pipelines<\/strong><\/a> on my video about them or on a blog post explaining how to use them with notebooks<\/a>.<\/p>\n

Kusto<\/strong> connections don’t appear when configuring rules for deployment pipelines. We can’t make a direct configuration of the rule to change the connection according to the environment.<\/p>\n

The image below shows how the Kusto connection doesn\u2019t appear by default among the Deployment Pipeline rules.<\/p>\n

 <\/p>\n

\"A<\/p>\n

 <\/p>\n

There is a 2nd option: Parameterize the connection in <\/em>Power BI<\/em><\/strong> and use the rules to change the parameter value.<\/em><\/p>\n

 <\/p>\n

Parameterizing the Kusto Connection<\/h2>\n

The Kusto<\/strong> connector in Power BI<\/strong> doesn’t allow parameters out of the box. I mean, even when you configure data source connections to always allow parameters (this is a power bi configuration), the kusto connection window doesn’t give you the option to create parameters.<\/p>\n

We need to go directly to the kusto query. A kusto query in power query<\/strong> has the first line like this:<\/p>\n

= AzureDataExplorer.Contents(“myKustoServerAddress”, “myKustoDatabase”)<\/em><\/p>\n

The two pieces of information we would like to turn into parameters are in string format. In this way, it’s easy to create Power Query<\/strong> parameters and “manually” use the parameters on this statement.<\/p>\n

In Power Query<\/strong>, you click the button Manage Parameters<\/strong> and on the parameters window you create two: KustoServer<\/strong> and KustoDB<\/strong>, both as Text<\/p>\n

\"A<\/p>\n

 <\/p>\n

Once they are created, the parameters appear as an additional query in Power Query<\/strong>. You select them to fill their default value. Usually you would like the default value to be the value for the development environment.<\/p>\n

 <\/p>\n

\"A<\/p>\n

 <\/p>\n

After publishing the semantic model, you can use parameter rules on the deployment pipeline, instead of connection rules. The parameters will be visible for you to create the rules and in this way allow an easy transition from the development environment to the test environment.<\/p>\n

 <\/p>\n

\"A<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

When organizing our SDLC (Software Development Lifecycle) in Power BI\/Fabric, we use Deployment Pipelines and create rules to change connection configurations every time we promote an object from one environment (dev for example) to another (test, for example). Kusto connections, on the other hand, are not so simple. You can check more about Deployment Pipelines……<\/p>\n","protected":false},"author":50808,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,159164,159166],"tags":[159053,126249,158997,101611],"coauthors":[6810],"class_list":["post-101585","post","type-post","status-publish","format-standard","hentry","category-blogs","category-microsoft-fabric","category-powerbi","tag-deployment-pipelines","tag-kusto","tag-microsoft-fabric","tag-power-bi"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/50808"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=101585"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101585\/revisions"}],"predecessor-version":[{"id":101590,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101585\/revisions\/101590"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=101585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=101585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=101585"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=101585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}