Patrick, Thanks for the video - you make it really look easy! Can you also show in one of your future videos - how can one make a matrix which is dynamic, that is allow for the end-user to dynamically change row and columns?
This should make SSRS developers happy. It definitely isn't for your typical ad hoc user. Is Microsoft just going to rebrand SSRS as Power BI Paginated Reports?
Hello, I was wondering if you could help me, I followed your step by step and I would like to congratulate you, you are very intelligent and you are helping me a lot. I'm from Brazil and I work with data. I have a tablix and it contains a measure called "Positivation" which is a distinct count of customers who buy the product I am evaluating, that same product is grouped by category, but when it creates a subtotal for the product category instead of keeping the distinct count is adding up. Based on your knowledge, could you help me?
I am confused with a more basic concept! How is creating a paginated report different from creating a PowerBI report? any help would be awesome! but as always thanks for the awesome video :D
Power BI report are limited in how much formatting you can do. In my opinion, they are much more powerful with all the visuals you can use and functionality you can use. But you cannot format them very precisely and one other other big drawback is when you print a Power BI report it comes out as a screenshot. On the other hand paginated reports let you design and format reports very finely (though not very easily always). They are very good tabular/matrix kind of reports and most importantly can be printed out as a report should be (that is you can print a multi-page table as a multi-page report and not as a screenshot). You can export a Paginated report will all formatting to Excel, you cannot do that with a Power BI Report. I would have preferred if Microsoft would continued to let Power BI become more flexible with regards to formatting and addressed this Export/Print issue better, but they probably figured that its better to integrate old style but very useful Paginated reports into Power BI.
How to group parameters in multiple screens? If there are some 20 drop-downs required, we can add them altogether but screen will be filled with parameters which is not so good looking. Hence, if we group the parameters in different screens and go next-next-finish wizard kind of option. Is that possible?
Hi , I have created buttons by using Bookmarks and in differnt pages i have created diff matrix Visualization by steeped layout off and those matrix expanded i.e. Expand All down level Hirearchy , Now issue is when ever i will move through buttons those matrix visualizations shrinking and i am expanding it every time. Thanks in advance.
From a design and development perspective it is. However, with the ability to host paginated reports in the Power BI Service, we decided to release some getting started videos for those new to this type of reporting.
Happened across something kind of crazy and cool accidentally. Right after playing video repeatedly hit the back arrow on your keyboard at different tempos.
Thank you for explaining this so well. I'm beginning my first paginated report for work and will use your tips.
Awesome! Best wishes in your journey!
Nice tips for only 13 minutes! Feels like Access report building from 1999!
First time I am watching this #PowerBI report builder, beautifully explained Patrick ,really great information ..
Patrick, Thanks for the video - you make it really look easy! Can you also show in one of your future videos - how can one make a matrix which is dynamic, that is allow for the end-user to dynamically change row and columns?
You are welcome. That is a great idea. I will add it to the queue.
This should make SSRS developers happy. It definitely isn't for your typical ad hoc user. Is Microsoft just going to rebrand SSRS as Power BI Paginated Reports?
Why is your UI different from pbi desktop.
What's yours? Thanks
Patrick, you're so smart
Hello, I was wondering if you could help me, I followed your step by step and I would like to congratulate you, you are very intelligent and you are helping me a lot. I'm from Brazil and I work with data. I have a tablix and it contains a measure called "Positivation" which is a distinct count of customers who buy the product I am evaluating, that same product is grouped by category, but when it creates a subtotal for the product category instead of keeping the distinct count is adding up. Based on your knowledge, could you help me?
I am confused with a more basic concept! How is creating a paginated report different from creating a PowerBI report? any help would be awesome! but as always thanks for the awesome video :D
Power BI report are limited in how much formatting you can do. In my opinion, they are much more powerful with all the visuals you can use and functionality you can use. But you cannot format them very precisely and one other other big drawback is when you print a Power BI report it comes out as a screenshot.
On the other hand paginated reports let you design and format reports very finely (though not very easily always). They are very good tabular/matrix kind of reports and most importantly can be printed out as a report should be (that is you can print a multi-page table as a multi-page report and not as a screenshot). You can export a Paginated report will all formatting to Excel, you cannot do that with a Power BI Report.
I would have preferred if Microsoft would continued to let Power BI become more flexible with regards to formatting and addressed this Export/Print issue better, but they probably figured that its better to integrate old style but very useful Paginated reports into Power BI.
@@mustafabiviji00711 thanks for the answer! Very helpful I was wondering the same thing.
How to group parameters in multiple screens?
If there are some 20 drop-downs required, we can add them altogether but screen will be filled with parameters which is not so good looking. Hence, if we group the parameters in different screens and go next-next-finish wizard kind of option. Is that possible?
Hi ,
I have created buttons by using Bookmarks and in differnt pages i have created diff matrix Visualization by steeped layout off and those matrix expanded i.e. Expand All down level Hirearchy , Now issue is when ever i will move through buttons those matrix visualizations shrinking and i am expanding it every time.
Thanks in advance.
In this video, Patrick is using Microsoft® SQL Server® 2016 Report Builder.
can you add RLS to paginated reports?
Thanks for the video! Can it be published to PowerBI service?
Yes. The workspace must be backed my Premium Capacity.
Does anybody know when we will have support for azure analysis service data source support?
Can you show how the final report looks like on PowerBI services?
Yes! More videos are planned. stay tuned!
How is it different from plain old SSRS? Thanks!
From a design and development perspective it is. However, with the ability to host paginated reports in the Power BI Service, we decided to release some getting started videos for those new to this type of reporting.
Happened across something kind of crazy and cool accidentally. Right after playing video repeatedly hit the back arrow on your keyboard at different tempos.
Power BI ??? It's just a SSRS not Power BI