Conflict issues in Power BI visual

[Niraj_vora0106]

Hi community,

I'm facing this following error when I'm trying to load Data in Table.

Please help!

[DeronHuskey]

Hi folks, I'm a little late to this party, but I recently encountered this error.  

I had initially set up a relationship between a lookup table and a fact table.  At some point in time, I modified the power query and changed the data type of the related field in my fact table for whole number to text.  Don't ask me why, just chalk it up to a bonehead move on my part. 

When Power BI refreshed the model, it attempted to join the whole number on my lookup table to the text on my fact table.  My measure was working well on lookup fields other than the one I fouled up.  When I dropped it into my table, Power BI choked and puked.

After changing the data type in my fact table back to whole number, it worked like a champ.

[v-jayw-msft]

Hi @Niraj_vora0106 ,

What data source you are using?

Please check the following topics.

https://community.powerbi.com/t5/Desktop/The-operation-was-cancelled-because-of-locking-conflicts/m-... 

https://community.powerbi.com/t5/Desktop/Concatenated-text-measures-causing-locking-conflict-error/m... 

https://community.powerbi.com/t5/Desktop/Locking-conflict-error-while-connecting-Oracle-database/m-p... 

Best Regards,

Jay

[amitchandak]

@Niraj_vora0106 , Copy details and share. Also refresh tables one by one to find the issue