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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DebbieE
Community Champion
Community Champion

Report Builder and Power BI working together?

I am working on regonfiguring some reports and I have noticed that there are lots of tables rather than visuals in the Power BI report with no measures added to the tables.

 

To me, these arent taking advantage of Power BI and should be in Report builder, but how well do power BI and Report Builder work together? can you drill through to a Power BI report to a Report Builder report and vice Versa?

 

Can you have Power BI Reports and Report Builder reports into the same app?

 

Personally I really dont like the design of these reports as they are so table heavy (With no measures)

Am I right in the above thinking, and if so, should I be recommending moving these into report Builder?

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

It all depends on what you're trying to do. If you want any sort of dynamic interaction with the report, then Power BI is the only option between the two. If you want dynamically-sized tables and/or pagination, then Report Builder is the only option among the two. For many reports, you could go one way or another depending on the preferences of the end-user and the report creator. Personally, I find the Report Builder to be powerful but clunky and irritating to work with (it's much older software).

 

You can certainly put both types of reports into the same app. I think you can potentially drill through in both directions but I haven't done this myself. You can even embed a paginated report inside a Power BI report with the paginate report visual: https://docs.microsoft.com/en-us/power-bi/visuals/paginated-report-visual

 

Do whatever works well for you and your audience.

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

It all depends on what you're trying to do. If you want any sort of dynamic interaction with the report, then Power BI is the only option between the two. If you want dynamically-sized tables and/or pagination, then Report Builder is the only option among the two. For many reports, you could go one way or another depending on the preferences of the end-user and the report creator. Personally, I find the Report Builder to be powerful but clunky and irritating to work with (it's much older software).

 

You can certainly put both types of reports into the same app. I think you can potentially drill through in both directions but I haven't done this myself. You can even embed a paginated report inside a Power BI report with the paginate report visual: https://docs.microsoft.com/en-us/power-bi/visuals/paginated-report-visual

 

Do whatever works well for you and your audience.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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