populate parameters using sql query while sending Data Driven subscription

[sakumar]

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.

[rajendraongole1 · Accepted solution]

Hi @sakumar - can you please refer the below threads

20221221 - Data Driven Subscriptions in Power BI (Alexandru Puiu)

Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate – Erik Sve...

Hope this helps.

[v-achippa · Accepted solution]

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

[v-achippa]

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

[v-achippa]

Hi @sakumar,

We wanted to kindly follow up to check if the solution I have provided for the issue worked.
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

[v-achippa]

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.
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

[rajendraongole1 · Accepted solution]

Hi @sakumar - can you please refer the below threads

20221221 - Data Driven Subscriptions in Power BI (Alexandru Puiu)

Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate – Erik Sve...

Hope this helps.