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
mrivney
Frequent Visitor

Converting Cognos reports to Power BI Developer and Power BI Report Builder : functionality ask

Hi all,

  I created a dataset, with Power BI Desktop, that was published to the Power BI Service.  My Power BI Report Builder reports access it as a data source.

  For a Power BI Report Builder report that has a matrix/table report, I'm able to set interactive sorting for each column of the report.  In Cognos one can do this too.  Also, in Cognos, one can summarize, group, and filter on each column of a table/matrix.  Is this possible in Power BI Report Builder?  I don't think so.  I've researched on the web and there was some broad information stating that some Cognos functionality is not available in Power BI Report Builder.  But it was not specific to what I was looking for.

Thanks, Mike.

1 ACCEPTED SOLUTION
josef78
Memorable Member
Memorable Member

For Paginated reports it is not possible during "interactive" time (there you can only sort columns). It possible only during developer design time. Reason is easy, Paginated report are static, not interactive.

 

But in Interactive Power BI reports is possible most of them during interactive time (sorting, filtering, slicing, and drill-up/down, up/down detail levels, and so on), and much more in user-friendly report modification.

View solution in original post

2 REPLIES 2
josef78
Memorable Member
Memorable Member

For Paginated reports it is not possible during "interactive" time (there you can only sort columns). It possible only during developer design time. Reason is easy, Paginated report are static, not interactive.

 

But in Interactive Power BI reports is possible most of them during interactive time (sorting, filtering, slicing, and drill-up/down, up/down detail levels, and so on), and much more in user-friendly report modification.

Hey josef78, thanks for the clarifying answer.  I appreciate it.  As I originally said, I researched on this but really couldn't find a definite answer.  This helps me out quite a bit.  Regardz, mrivney.

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.