Deployment Pipelines - Support Incremental Refresh with Detect Data Changes
We are leveraging Power BI models configured with Incremental Refresh and Detect Data Changes (IRDDC), using monthly partitions and a polling expression to track the maximum 'last update' date via a refreshBookmark. While Deployment Pipelines streamline model promotion, they currently lack the ability to control partition settings or manage the refreshBookmark during deployment.
We request the addition of deployment options that allow us to:
- Preserve or overwrite the refreshBookmark based on deployment context.
- Exclude partition metadata from deployments when necessary to avoid unintended refresh behavior.
- Strategically update semantic models without disrupting incremental refresh logic.
Existing 3rd Party Tools such as ALM Toolkit and TE3 provide the following options to achieve this:
These capabilities are essential for maintaining data integrity and operational efficiency in enterprise environments using IRDDC. While tools like ALM Toolkit and Tabular Editor offer workarounds, native support in Deployment Pipelines would significantly enhance governance and automation.
2 Comments
- Michaeldias
Helper I
Yes please. Doing this manually instead of going through our pipeline of 10 workspaces is risky indeed - Michaeldias
Helper I
Yes please. Doing this manually instead of going through our pipeline of 10 workspaces is risky indeed
Recent ideas
Improve Metadata and Lineage Support for Power BI Paginated Reports
Power BI Service currently lacks built-in capabilities to retrieve and manage metadata for deployed Paginated Reports (.RDL). We would like Microsoft to provide APIs and/or native features to: Ret...v-koyag5 hours agoMicrosoft EmployeeNew19Views1like0CommentsDynamic Labels for Subtotals and Totals in Power BI Matrices
Power BI should support dynamic expressions for subtotal and total labels in Matrix visuals. Currently, subtotal labels are static, which limits report usability and forces report authors to implemen...KellyMc14 hours agoNew MemberNew12Views0likes0CommentsCustom page navigation and foldable menus with less bookmarks (modern web UI inspired)
I recently watched a lot tutorials on how to achieve page navigations as common in modern web frameworks as Bootstrap including foldable site menusbars and dropdown menus. Or building toggle buttons....Famondir15 hours agoNew MemberNew98Views1like1Comment