Forum Discussion
populate parameters using sql query while sending Data Driven subscription
how to use SQL query in Power Bi data driven subscription to populate parametes based through SQL query. It was there in SSRS. I am not getting option for that . Any help will be highly appriciated.
Hi sakumar - can you please refer the below threads
20221221 - Data Driven Subscriptions in Power BI (Alexandru Puiu)
Hope this helps.
Hi sakumar,
Thank you for reaching out to Microsoft Fabric Community.
Power bi does not have a direct 'data-driven subscription' feature like SSRS, where you can use an sql query to populate parameters dynamically. But we can achieve a similar functionality using Dynamic per Recipient Subscription in Power bi paginated reports.
- Create a SQL table that stores recipient emails and report parameters and add this table to the power bi dataset.
- In the power bi service, go to the paginated report and select Dynamic per recipient subscription. This option is only available in Power BI Premium or Fabric capacities, please make a note of it.
- And then map the subscription fields to report parameters.
Thank you rajendraongole1 for the prompt response, please refer the below links which rajendra has shared.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
5 Replies
Hi sakumar - can you please refer the below threads
20221221 - Data Driven Subscriptions in Power BI (Alexandru Puiu)
Hope this helps.
Hi sakumar,
Thank you for reaching out to Microsoft Fabric Community.
Power bi does not have a direct 'data-driven subscription' feature like SSRS, where you can use an sql query to populate parameters dynamically. But we can achieve a similar functionality using Dynamic per Recipient Subscription in Power bi paginated reports.
- Create a SQL table that stores recipient emails and report parameters and add this table to the power bi dataset.
- In the power bi service, go to the paginated report and select Dynamic per recipient subscription. This option is only available in Power BI Premium or Fabric capacities, please make a note of it.
- And then map the subscription fields to report parameters.
Thank you rajendraongole1 for the prompt response, please refer the below links which rajendra has shared.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi sakumar,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa