Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
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
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
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
User | Count |
---|---|
3 | |
3 | |
2 | |
1 | |
1 |
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 |