Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

App to manage reference data (slowly changing dimension)

Hi, we have lots of Enterprise data that requires reference data to underpin PowerBi reporting.

Historically uses ftp xls files and these are ingested into the data sat. Over 50% fail due to data errors.

Most are very simple (see example below) so thinking of using PowerApp over sharepoint list (best licencing option).

This list is used a dimension in the data model (using the "slowly changing dimension" framework.

My question is about the rules/mechanism that can best meet the need (preventing overlapping dates).

Example data

Product      Category     From Date     ToDate

bus             transport    01/01/20        01/01/22

tree            plant           01/01/19        01/01/30

bus             vehicle        01/01/21        01/01/25  ** (this being an invalid record)


Has anybody any experience of this.. Many Thx


Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (46,965)