Power BI Deployment Pipelines - April 2021
Power BI release management
with Deployment Pipelines
Asanka Padmakumara
Thanks to our sponsors
Speaker info
•
More than 10 years in BI and Data
Warehousing
•
Regular speaker at data-related
events
•
Blog:
asankap.wordpress.com
•
Linked In:
linkedin.com/in/asankapadmaku
mara
•
Twitter:
@asanka_e
Asanka Padmakumara
Senior Business Intelligence Consultant
Agenda
•
Deployment Scenario
•
Problems
•
The Solution – Power BI Deployment Pipelines
•
Demo
•
Best Practices
•
Current Limitations
•
Q&A
The Scenario
Steps to follow
Issues in the approach
•
Maintaining multiple copies of reports
•
Amount of time to make a release
•
Effort to make a release
•
Difficult with Large data model
•
Need to refresh in each source connection changes
•
Need to deploy to service in each connection changes
•
User errors due to manual works
The Solution
•
Power BI Deployment Pipelines
•
Introduced to manage deployment of
organisational content between
multiple environment
•
Preview in 2020-May
•
GA in 2020-Sep
•
Supports Development, Test and
Production Workspaces
Power BI Deployment Pipelines
Deployment Rules
•
Allows to change Parameters and Data Source connection information
when moving between environments
•
Two types of rules
•
Data Source Rules
•
Parameter Rules
•
Not all data sources support data source rules
•
Use Parameter Rules when not supported
Demo Time!
Best Practices
•
Use parameters in your model to store connection details
•
Separate models and reports
•
Use parameters to control data volume in Dev
•
Use workspace permission to control who can deploy to Prod
•
Don’t download Prod/Test PBIX files for quick fixes
Limitations
•
Only available in Premium, Premium per user and Embedded
•
Can not used with
•
Template app workspaces
•
Paginated reports
•
Dataflows
•
PUSH datasets
•
Only one workspace for a pipeline, rest are created automatically
•
Not copied
•
Role assignment
•
Refresh schedule
•
Data source credentials
•
Sensitivity labels are not supported
•
No version controlling
Resources to study more
•
https://docs.microsoft.com/en-us/power-bi/create-
reports/deployment-pipelines-get-started
•
https://docs.microsoft.com/en-us/power-bi/create-
reports/deployment-pipelines-best-practices
Thank you
•
Connect to me at:
•
Blog:
asankap.wordpress.com
•
Linked In:
linkedin.com/in/asankapadmakumara
•
Twitter:
@asanka_e
•
Stay online for my live Q&A sessions
Discover the latest in Power BI release management with Deployment Pipelines in April 2021. Learn about the agenda, speaker insights, scenario, steps to follow, issues faced, and the solution provided by Deployment Pipelines for managing organizational content deployment efficiently across multiple environments.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
April 2021 Power BI release management with Deployment Pipelines Asanka Padmakumara April 2021
April 2021 Thanks to our sponsors April 2021
April 2021 Speaker info Asanka Padmakumara Senior Business Intelligence Consultant More than 10 years in BI and Data Warehousing Regular speaker at data-related events Blog: asankap.wordpress.com Linked In: linkedin.com/in/asankapadmaku mara Twitter: @asanka_e April 2021
April 2021 Agenda Deployment Scenario Problems The Solution Power BI Deployment Pipelines Demo Best Practices Current Limitations Q&A April 2021
April 2021 The Scenario Dev Source System Test Source System Prod Source System Dev Workspace Test Workspace Prod Workspace Sam April 2021
April 2021 Steps to follow Open each report and change connection to deployed model in service. Open each model and edit connection strings and refresh in local PC Deploy each model to Test/Prod workspaces. Deploy each reports to Test/Prod workspaces Copy models and reports to different folders, test and prod April 2021
April 2021 Issues in the approach Maintaining multiple copies of reports Amount of time to make a release Effort to make a release Difficult with Large data model Need to refresh in each source connection changes Need to deploy to service in each connection changes User errors due to manual works April 2021
April 2021 The Solution Power BI Deployment Pipelines Introduced to manage deployment of organisational content between multiple environment Preview in 2020-May GA in 2020-Sep Supports Development, Test and Production Workspaces April 2021
Power BI Deployment Pipelines April 2021 Prod Source System Dev Source System Test Source System Rules Rules Prod Workspace Dev Workspace Test Workspace April 2021
April 2021 Deployment Rules Allows to change Parameters and Data Source connection information when moving between environments Two types of rules Data Source Rules Parameter Rules Not all data sources support data source rules Use Parameter Rules when not supported April 2021
April 2021 Demo Time! April 2021
April 2021 Best Practices Use parameters in your model to store connection details Separate models and reports Use parameters to control data volume in Dev Use workspace permission to control who can deploy to Prod Don t download Prod/Test PBIX files for quick fixes April 2021
April 2021 Limitations Only available in Premium, Premium per user and Embedded Can not used with Template app workspaces Paginated reports Dataflows PUSH datasets Only one workspace for a pipeline, rest are created automatically Not copied Role assignment Refresh schedule Data source credentials Sensitivity labels are not supported No version controlling April 2021
April 2021 Resources to study more https://docs.microsoft.com/en-us/power-bi/create- reports/deployment-pipelines-get-started https://docs.microsoft.com/en-us/power-bi/create- reports/deployment-pipelines-best-practices April 2021
April 2021 Thank you Connect to me at: Blog: asankap.wordpress.com Linked In: linkedin.com/in/asankapadmakumara Twitter: @asanka_e Stay online for my live Q&A sessions April 2021
