Is it possible to create connection in PowerBi dataset using the table existing in Azure Data Explorer programmatically(using c#)

Sanjana P.S 1 Reputation point
2020-11-17T12:49:20.313+00:00

We have tried following approaches but nothing helped:
Approach 1 : Using ADOMD and AMO libraries create the dataset with data source connection as Azure Data Explorer
Blocker :
The challenge is, using ADOMD library the dataset is being created while setting Azure Data Explorer as data source. But while trying to create report for the newly create dataset in browser. It is giving error . It means the data source connection is not forming with Azure Data Explorer.

Approach 2 : Find the connection details of data source in dataset using ADOMD and AMO libraries.
Blocker:

Only the connection string of power bi is available in properties, The connection details of existing data source connection(Azure Blob Storage/ Azure Data Explorer) is not present in the properties of retrieved dataset details.

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,576 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
502 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee
    2020-11-20T05:52:28.627+00:00

    Hello @Sanjana P.S ,

    If you are trying to connect from C# to a data source underneath a PBI report, you need to get the details of the data source. Try right-clicking on the data set and choose "Edit Query". The Power Query Editor will open. Choose "Advanced Editor" and use the values from the Kusto.Contents() function.

    Hope this helps. Do let us know if you any further queries.