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
Icon for Super User rankSuper 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. 

SalvadorBruzon's avatar
SalvadorBruzon
New Member
2 years ago

Sahir, kudos to you!

 

I have a similar situation with a bit more complex condition. Regarding point (3), isn't it Power Automate Flow the one triggering Power BI Subscription conditionally? it reads to me the other way around ðŸ¤”.

 

Thanks,