question

SanjanaPS-5606 avatar image
0 Votes"
SanjanaPS-5606 asked PRADEEPCHEEKATLA-MSFT commented

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

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-storageazure-data-explorer
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SanjanaPS-5606,

Welcome to the Microsoft Q&A platform.

I’m working with the product team and get back to you when I have more information.

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @SanjanaPS-5606,

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.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SanjanaPS-5606,

Just checking in to see if the above answer helped. If this answers your query, do click “Accept Answer” and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @SanjanaPS-5606,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

Take care & stay safe!

0 Votes 0 ·

Hi @PRADEEPCHEEKATLA-MSFT,

Apologies for the delayed response.
We have tried using the values from the Kusto.Contents() for creating datasource connection but it failed. It would be helpful if you can suggest/share any support document or sample C# code to connect the Power BI dataset to existing table in Azure Data Explorer programmatically.

0 Votes 0 ·

Hello @SanjanaPS-5606,

We are reaching out to the internal team to get more help on this, I will update you once we hear back from them.

0 Votes 0 ·