Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mhamilt1
Regular Visitor

Refesh unique constraint and RI issue

Hi

 

We have a dimension table that we wish to partition but we do not have a good date to use so we are adding a min first transaction date. We are doing this so we can improve our refresh time.

We have included a 24 month rolling window policy.

The join to fact table is one to many.

 

Now when I refresh I get a duplicate error.

This is because the date must.change and add the same dimension row into 2 partitions. I am expecting the old date to drop out of the table but I think the new data may be added before the old data outside the rolling window is deleted. Could this be true? Is there anyway to delete the old data before adding the new so that I avoid this duplicate ID in the dimension side of the many to one join?

 

Because the join is one to many

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Yes, you can use your tool of choice to refresh individual partitions (including emptying them)  in your desired sequence.  Can be SSMS, Powershell, etc.  Anything that can run XMLA queries.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Yes, you can use your tool of choice to refresh individual partitions (including emptying them)  in your desired sequence.  Can be SSMS, Powershell, etc.  Anything that can run XMLA queries.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors