Connecting Data Sources Between Main Report and Subreport in Power BI

[Aartibhilare]

Hello,

I have created a subreport inside the main report in Power BI Report Builder.

I have a couple of questions:

1. How can I connect the data sources between the main report and the subreport? If I make changes to the main report’s data source, I want the subreport to automatically reflect these changes (without needing to manually update the subreport’s data source).

2. If I share the report, which is connected to my local SQL database, with a teammate (who will point the report to their own local SQL database), will the subreport work without me needing to share the subreport file separately? In other words, will the subreport automatically point to the new database without additional configuration?

Thanks in advance for your help!

[Anonymous · Accepted solution]

Hi  @Aartibhilare 

Q1:You can create a shared data source in the main report and save the shared data source (.rds file) to a shared location or within your project folder. Then link both the main report and the subreport to this shared data source.

Q2:If the subreport is embedded within the main report, it is packaged along with the main report file. This means you don’t need to share the subreport file separately.

Best Regards,

Jayleny

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