Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Multiple Database Connection in paginated reports

I have two two databases one is A and other is B. I want know if iwe can combine the databases in paginated reports like power bi, please help me and Which was is better for Dataset creation in paginated reports - via SQL Query or from Power BI Datasets?
2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , the Power bi dataset can work here, as you can combine two sources in power bi use them in a paginated report You have data modeling complications handled in power bi

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

we tried this option working fine is their any draw back when we are calling power bi dataset in power bi report buider and publish the report from report builder to service.please let us know 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.