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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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.

 

 

amitchandak
Super User
Super User

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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