How to execute a DAX query on a Power BI Service dataset via C#/REST ?

[Anonymous]

Hi All,

I am exploring if the following scenario is currently supported.

Background

1. I have a dataset published to a Power BI Workspace
2. The dataset is configured to work in Import mode.
3. License is professional

Scenario

1. Execute DAX queries on this dataset via REST API or some C# wrapper.
2. The information retrieved could be used for some back end business application logic. E.g. Send alerts to customers to notify about some business conditions, Display data on a custom web page in a custom way

Thanks,

Sau

[Gentiana]

You are now able to do this. Check out this public REST API: Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Docs

[Tutu_in_YYC]

OMG

[Anonymous]

HI @Anonymous,

As ibarrau said, I don't think it is possible to execute the Dax formula with the rest API. Dax expression works on the AS tabular data model, you can't push these formulas from external.

In my opinion, I'd like to suggest you try to use power bi Automate to trace the dataset records and send alert messages based on some conditions.

Integrate data alerts with Power Automate 
Regards,

Xiaoxin Sheng

[ibarrau]

Hi. I don't think you can do that with a Pro license. The only way to query a dataset in Power Bi Service is if it is in a Premium Capacity Worskpace that will generate an endpoint. You can connect to it as if it was an Azure Analysis Service. I don't know about C# to help with the code, but I know that it's the only way it will allow you to query that data.

Hope this helps,