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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Niraj_vora0106
Helper III
Helper III

Conflict issues in Power BI visual

Hi community,

 

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

Error 1.png

 

 

 

 

 

 

 

 

Please help!

3 REPLIES 3
DeronHuskey
New Member

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
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.