Forum Discussion

annhwallinger's avatar
annhwallinger
Helper I
1 year ago

Power BI Embedded Paginated Report Dynamic Data SOURCE

Good day,   I know you can do dynamic 'dataset' binding for paginated reports, but I have been unable to determine if you can do dynamic 'data source' binding?    For example: Workspace A conta...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi annhwallinger ,

 

I think you can try Microsoft Report Builder to create your report.

As far as I know, warehouse supports OLE DB, ODBC, JDBC for connectivity. These connectors are available in Microsoft report builder, which then supports customizing the connection string with the parameter.

For reference: 
Dynamic Connection Strings in Reporting Services 2005 – SQLServerCentral
Implement Dynamic Data Sources in SSRS (mssqltips.com)

Create data connection strings in Report Builder - SQL Server Reporting Services (SSRS) | Microsoft Learn

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.