Power BI Report Builder connecting multiple data sources

[mp390988]

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

[v-pgoloju]

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

[v-pgoloju]

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

[v-pgoloju]

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

[v-pgoloju · Accepted solution]

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