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.

 

 

  • annhwallinger's avatar
    annhwallinger
    Helper I
    1 year ago

    Hi Rico,

     

    Thank you for your reply. I actually did try that but as soon as I parameterized the connection I was no longer able to publish to Power BI. It worked locally and I have used it in SSRS but it wouldn't publish to powerbi.com. Do you know if this is something that is supposed to be supported?

     

    Thank you,

     

    Ann Wallinger