search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.28k stars 21.45k forks source link

Could AAS connect to Azure Kusto as the data source? #111620

Closed YoHo-Wang closed 1 year ago

YoHo-Wang commented 1 year ago

In Power BI, we can leverage the Power Query to connect Kusto dataset. And currently we want to connect the Kusto in AAS, is there any recommended method? I didn't find the Kusto is listed in the AAS data source from this document: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource

Thanks!

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

YashikaTyagii commented 1 year ago

@YoHo-Wang Thanks for your feedback! We will investigate and update as appropriate.

RamanathanChinnappan-MSFT commented 1 year ago

@YoHo-Wang

Thank you for bringing this to our attention.

To connect to Kusto data source in Azure Analysis Services, you can use the "Azure Analysis Services database" connector in Power BI Desktop. Here are the steps to connect to Kusto data source in Azure Analysis Services:

  1. In Power BI Desktop, click Get Data > Azure > Azure Analysis Services database.
  2. In Server, paste the server name of your Azure Analysis Services instance.
  3. In Database, enter the name of the database that contains the Kusto data source.

When prompted, enter your credentials. The account you enter must have at least read permissions for the Kusto data source.

After you connect to the Azure Analysis Services database, you can use the "Import" or "DirectQuery" mode to load data from the Kusto data source.

Note that Kusto is not listed as a separate data source in Azure Analysis Services because it is part of the Azure Data Explorer service. However, you can still connect to Kusto data source in Azure Analysis Services by using the "Azure Analysis Services database" connector in Power BI Desktop.

For an issue like this, I'd recommend you create a support ticket since the support team will be able to respond much more quickly and have a conversation with you to figure out what could be going on.

YoHo-Wang commented 1 year ago

@RamanathanChinnappan-MSFT Thanks for your answer.

But it seems still leverage the PowerBI to connect the Kusto endpoint. Sorry my question might be confused. I'm looking for a method in .Net library (Microsoft.AnalysisServices.Tabular) to connect the Kusto endpoint. Could you help to give some guidance?

RamanathanChinnappan-MSFT commented 1 year ago

@YoHo-Wang

You can use the KustoConnectionStringBuilder class in the Microsoft.Azure.Kusto.Data namespace to connect to the Kusto endpoint. Here is an example of how to use it:

using Microsoft.Azure.Kusto.Data; using Microsoft.Azure.Kusto.Data.Common;

var kustoConnectionStringBuilder = new KustoConnectionStringBuilder("https://.kusto.windows.net"); kustoConnectionStringBuilder.WithAadApplicationKeyAuthentication("", "", "");

var kustoConnection = new KustoConnection(kustoConnectionStringBuilder.ToString()); kustoConnection.Open();

Replace , , , and with the appropriate values.

Note that you need to install the Microsoft.Azure.Kusto.Data NuGet package to use this class.

Since this issue isn't directly related to improving our docs, and to gain a better understanding of your issue, I'd recommend working closer with our support team via an [Azure support request] (https://docs.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request). Or you can leverage our Q&A forum by posting your issue there so our community, and MVPs can further assist you in troubleshooting this issue or finding potential workarounds.

[Teams Q&A forum] (https://docs.microsoft.com/en-us/answers/topics/46488/office-teams-windows-itpro.html) for technical questions about the configuration and administration of Microsoft Teams on Windows. [Microsoft Teams Community forum] (https://answers.microsoft.com/en-us/msteams/forum?sort=LastReplyDate&dir=Desc&tab=All&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=All&isFilterExpanded=false&page=1