Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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!

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.



Community Support
Community Support

Hi @Niraj_vora0106 ,


What data source you are using?

Please check the following topics. 


Best Regards,


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

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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors