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.
Hi community,
I'm facing this following error when I'm trying to load Data in Table.
Please help!
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.
Hi @Niraj_vora0106 ,
What data source you are using?
Please check the following topics.
Best Regards,
Jay
@Niraj_vora0106 , Copy details and share. Also refresh tables one by one to find the issue
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
73 | |
42 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |