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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
TANA
Helper II
Helper II

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

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!




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

all good now

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.