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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

How to connect two table (1:1 relationship) and one table was from dataset in the same workspace

Hi, 

 

I pulled data from one of Power BI datasets in the same workspace. Then I initiated the relationship between the target table and dataset table. The relationship was detected as one on one, both direction and active. 

 

However, when I tried to get data from one column in dataset table, I received the following message:

The column 'xxx' either doesn't exist or doesn't have a relationship to any table available in the current context. 

 

Can you please help me to resove this? Thanks, 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks for yr time. It is all good now. I think I found the solution. 

View solution in original post

3 REPLIES 3
vanessafvg
Super User
Super User

please can you provide screenshots?  are you sure nothing has changed in the source?  assuming you are using direct query to another semantic model to be clear?

 

then can you please provide the column and how are using it, are you placing it in a visual, using it in a measure?

 

 

 

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Anonymous
Not applicable

Thanks for yr time. It is all good now. I think I found the solution. 

Anonymous
Not applicable

all good now

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors