Can we consume Power BI dataset (or Datamart) from ASP.Net application

[amjee]

Hi There,

I have one ASP.Net Console Application and I would like to check if there is any ways to fetch some data here from one of my power BI dataset?

not talking about embedded report or dashboard. I am searching if I can read power Bi data set (or a power Bi data mart) contents in and from my asp.net app? Like via any ado.net or oledb connection string etc.?

thanks a lot...

[NandanHegde · Accepted solution]

you can use the REST API :

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

[bguillory2]

Using .net using ADOMD is another good option.

https://stackoverflow.com/questions/38478734/ho-to-connect-to-power-bi-dataset-using-adomd-net