Forum Discussion

R1k91's avatar
R1k91
Icon for Super User rankSuper User
3 years ago

are you publishing on Power BI Report Server or Power BI Service?

- Power BI Report Server has Data Driven Subscription feature that does what you need

SSRS Data Driven Subscription (mssqltips.com)

- Power BI Service doens't support this yet. you should use something that programmatically calls Power BI export APIs and then sends the email for example with Power Automate

Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate – Erik Svensen – Blog about Power BI, Power Apps, Power Query (wordpress.com)

  • sophiechin's avatar
    sophiechin
    Frequent Visitor
    3 years ago

    Thank you so much for the response. Currently, I use Power Automate but besides only sending it to each merchant email, I also need to save the the daily sales reports in different folders based on merchant's name as well. May you please elaborate how can I let the report send the email to each merchant and save it to different folder of each merchant name in the same flow as well? I really really need to do it. Thank you so much!