Data Science Wire

Auto-repairing missing keys in semantic models

Reddit r/MicrosoftFabric4d4 min read

Back in the days of Multidimensional modeling, the OLAP engine would enforce better data integrity constraints. And it would assist with processing/refresh operations. Eg. you could refresh a fact partition, and ask the service itself to do related work to update dimensions. Many decades later we are using "Tabular modeling" and the engine doesn't care about RI violations or missing keys. And Fabric makes us do all the work to track down invalid relationships in order to repair them. For example Microsoft lets us babysit our missing relationship keys with the "sempy" library like so: https://l

Read the full story at Reddit r/MicrosoftFabric →

More in Engineering