Forum Discussion

rawandshoraa's avatar
rawandshoraa
Frequent Visitor
3 years ago

conditional subscription

Greetings, i want to add condition on a subscription, if there is no date, don't run the subscribtion. what to do? 
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
3 years ago

Hello foodd,

 

You can achieve this functionality using a workaround by utilizing Power Automate along with Power BI's REST API. 

  1. Create a Flow in Power Automate:

    • Create a Power Automate (Flow) that checks whether there is a date in your dataset that triggers the subscription.
    • If the date is present, the Flow proceeds to the next step.
    • If the date is not present, the Flow terminates without proceeding further.

  2. Use the Power BI REST API:

    • In Power Automate, use the "HTTP - HTTP" action to call the Power BI REST API to trigger the subscription only if the condition is met.
    • You'll need to authenticate your Power BI account and generate a token for API authentication.

  3. Configure the Power BI Subscription:

    • Set up a Power BI subscription that triggers the Power Automate Flow.

Let me know if you might require further assistance. 

foodd's avatar
foodd
Community Champion
3 years ago

Sahir_Maharaj , thank you for adding a scenario, however, the reply to rawandshoraa was a genuinely open and probing question so that members of the Forum are able to quickly offer appropriate advice or alternative logic.   Is this an ask for help in creating a DAX expression?   Is this an ask for help in setting up a Subscription to the Power BI Service?   Is this an ask on how to set up a Security Group named "Subscription"?  Is this an ask for assistance in constructing a Power Automate Flow?   Etcetera.

 

I believe you understand my point.