populate parameters using sql query while sending Data Driven subscription

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 Svensen – Blog about Power BI, Power Apps, Power Query

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