Download - Premium Per User-Paginated Reports
![Page 1: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/1.jpg)
Premium Per User-Paginated ReportsChristian Cote
![Page 2: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/2.jpg)
WhoamiData Engineer/Solution Architect at Avanade
On-Prem ETL development using various ETL tools: DTS / SSIS, Hummungbird Genio, Informatica, Datastage
DW Experience in various domains: Pharmaceutical, finance, insurance, manufacturing and education
Specialized in Data warehouse/BI/Big Data
Writer of several books on data integration
Microsoft Data Platform Most Valuable Professional (MVP)
Montreal Data Platform User group leader
![Page 3: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/3.jpg)
Agenda
Power BI Premium Flavors
Dataflow features
Paginated Reports
![Page 4: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/4.jpg)
Power BI Premium different flavors
3
Premium regular license
• 5000 users for P1 capacity
• Pro vs Viewers
• Greater capacity: 400GB Model
Premium sandbox (embedded)
• Ideal for IT development
• Used to embed reports into web pages or applications
Premium Per user
• Save costs
• Less than 250 users (ideally)
• 100 GB Model
![Page 5: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/5.jpg)
Power BI Premium Per User VS Capacity
Feature description Per User Per Capacity
Model size limit 100 GB Up to 400 GB
Refresh rate 48/day 48/day
Paginated reports ✔ ✔
AI capabilities (AutoML, Impact Analysis, Cognitive Services) ✔ ✔
Advanced dataflows features, such as DirectQuery ✔ ✔
Usage-based aggregate optimization ✔ ✔
Deployment Pipelines ✔ ✔
XMLA endpoint connectivity ✔ ✔
Enhanced automatic page refresh ✔ ✔
Multi-Geo support X ✔
Unlimited distribution X ✔
Power BI reports on-premises X ✔
Bring Your Own Key (BYOK) ✔ * ✔
![Page 6: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/6.jpg)
Dedicated Capacity
• Dataflows with incremental refresh, enhanced computation
• Up to 48 refreshes during the day
• Al capabilities (AutoML)• Predictive analysis• Sentiment Analysis
• XMLA endpoints• Paginated reports• Deployment Pipelines• Advanced security
4
![Page 7: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/7.jpg)
Different Audiences/Users
![Page 8: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/8.jpg)
Power BI Dataflows• What’s missing in my model from our
official data sources?
• No-Code data prep
• Prepare data with just few clicks
• Premium: Enhanced compute engine
• Premium: Linked/Computed entities
• Premium: Incremental refresh
![Page 9: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/9.jpg)
XMLA Endpoints
![Page 10: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/10.jpg)
Demo: Power BI Premium
![Page 11: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/11.jpg)
Paginated Reports
5
Origins
• Reporting Services
• Pixel perfect reports
• Sometimes used to render invoices
Power BI Report Builder
• Power Bl dataset VS other sources
• Web based tool in the future?
• Migrate your on-premises Reporting Services to the clouds
Data Model
• Can access data sources directly – direct query mode from SSRS
• Can use existing Power BI data model
![Page 12: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/12.jpg)
PBI Paginated reports/SSRS origins
<2004 2004 2005 2008 2008R2 2012 2014 2016-9/Premium
Crystal Reports
SSRS 1.0 SSRS 2.0 SSRS 3.0 SSRS 3.1 SSRS 4.1SSRS 4.0SSRS 5.0PBI RS
PBI Paginated
![Page 13: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/13.jpg)
Paginated Reports from an IT perspective
• Code behind
• VB .Net code
• Scenario: translations
• Subscriptions
6
![Page 14: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/14.jpg)
Demo: Paginated Reports
![Page 15: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/15.jpg)
Learning Paginated Reports
Power BI Paginated Reports in a Day course - Power BI | Microsoft Docs
![Page 16: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/16.jpg)
Questions?
![Page 17: Premium Per User-Paginated Reports](https://reader035.vdocuments.us/reader035/viewer/2022071613/6157d907ce5a9d02d46fc64b/html5/thumbnails/17.jpg)
Thank you!