Forum Discussion

Post Partisan

1 year ago

Solved

Power BI Report Builder connecting multiple data sources

Hi,

I need to create a paginated report.

I have already installed report builder.

I need to bring in 2 data sources, one is a sharepoint list and the other is data from sql.

I then need to connect these 2 data sources.

But I realised you cannot join data sources in Report Builder.

So what do I do?

Thanks

Anonymous
1 year ago
Hi mp390988,

Thank you for reaching out to the Microsoft Fabric Forum Community.

For your scenario, the most effective approach would be to use a centralized data source by combining the two data sources into one before bringing it into the report.

Best regards,
Prasanna Kumar

4 Replies

Anonymous
Not applicable
1 year ago
Hi mp390988,

Thank you for reaching out to the Microsoft Fabric Forum Community.

For your scenario, the most effective approach would be to use a centralized data source by combining the two data sources into one before bringing it into the report.

Best regards,
Prasanna Kumar
Anonymous
Not applicable
1 year ago
Hi mp390988,

Just following up to see if the suggestion provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar
Anonymous
Not applicable
1 year ago
Hi mp390988,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

Warm regards,

Prasanna Kumar
Anonymous
Not applicable
1 year ago
Hi mp390988,

Just following up to see if the solution provided were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar