Forum Discussion

johnsebastian97's avatar
johnsebastian97
Frequent Visitor
1 year ago
Solved

Power BI Paginated Report Subscription - Send Only When Data is Available

Hello dears of the forum,

 

I have a Power BI Paginated Report, and I want to set up a scheduled subscription to receive the report via email. However, I only want the report to be sent if there is data available - if the dataset returns no records, the email should not be sent.

Is there a way to configure this within Power BI query itself?

Any guidance or best practices would be greatly appreciated!

 

Thanks in advance!

Need Help
Show and Tell
  • johnsebastian97's avatar
    johnsebastian97
    1 year ago

    Akash_Varuna I could find a way by putting the query into a temprary table and making it throw an error if row count 0, but im looking for a better approach.

6 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    Hi johnsebastian97 I don't think there is a way to set trigger for this kind of scenarios in Power Query you would have to use automation for this Probably Power Automate which will trigger on this use case

    If this post helped please do give a kudos and accept this as a solution 

    Thanks In Advance 

  • johnsebastian97's avatar
    johnsebastian97
    Frequent Visitor
    1 year ago

    Akash_Varuna I could find a way by putting the query into a temprary table and making it throw an error if row count 0, but im looking for a better approach.

    • Akash_Varuna's avatar
      Akash_Varuna
      Super User
      1 year ago

      Oh That is intresting the way you did it could you give me more contest on how you achived this please just for knowledge 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi johnsebastian97,

    Thank you for reaching out in Microsoft Community Forum.

    Thank you  Akash_Varuna for the helpful response.

    We hope your issue has been resolved. Please share the process here and click on "Accept as solution" so that community members facing a similar issue can find the solution quickly.

    Please continue using Microsoft community forum.

    Regards,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi johnsebastian97,

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

    Thank you,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi johnsebastian97,

    I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
    If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
    If you need any further assistance, feel free to reach out.

    Please continue using Microsoft community forum.

    Thank you,
    Pavan.