Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am exploring if the following scenario is currently supported.
Background
Scenario
Thanks,
Sau
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
OMG
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
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,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.