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

Question

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.

Answer 1

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.