Power BI Embedded Paginated Report Dynamic Data SOURCE

[annhwallinger]

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 contains a Fabric Warehouse that can be reached through Connection String A

• Workspace B contains a Fabric Warehouse that can be reached through Connection String B

Is there a way in the binding process to tell the RDL file which Connection String I want it to use?

Thank you,

Ann

[v-rzhou-msft]

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

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]

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