Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am a pro PowerBI user and use RangeStart <= [partition date] < RangeEnd in this way.
Even after doing in that way, I am getting the same error. Will it happen if that unique ID is present in archived data and got updated in a recent refresh
Currently, I am using modified date to fetch data and detect changes. Instead, can I use created at date to fetch data and modified at date to detect changes. Will I escape from duplicate error.
Data source error: Column '<oii>class_id</oii>' in Table '<oii>dw v_fact_classes</oii>' contains a duplicate value '1333550' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Will it happen if that unique ID is present in archived data and got updated in a recent refresh
Yes, it will. Remember this is incremental refresh, not differential refresh. Incremental refresh only works with immutable data, If your data is mutable you need to manually refresh all affected partitions.
It is not allowed probably because it has a relationship to another table and this table is the one side of a one to many or one to one. Scroll to the right to see the rest of the error.
Or you mayve have to change the relationship to many to many or reverse the one to many if this is the fact and the other table is the dimension
I have updated the full reason.
User | Count |
---|---|
32 | |
31 | |
28 | |
25 | |
22 |
User | Count |
---|---|
52 | |
42 | |
37 | |
36 | |
31 |