topic Re: Power BI Embedded Paginated Report Dynamic Data SOURCE in Developer

Power BI Embedded Paginated Report Dynamic Data SOURCE

annhwallinger — Wed, 25 Sep 2024 12:07:04 GMT

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

Re: Power BI Embedded Paginated Report Dynamic Data SOURCE

Anonymous — Thu, 26 Sep 2024 05:47:01 GMT

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.

Re: Power BI Embedded Paginated Report Dynamic Data SOURCE

annhwallinger — Thu, 26 Sep 2024 11:14:37 GMT

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