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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Relationship in Custom Dataset

AjayKiran_0-1662388112838.png

Workdone:

  • Created a Dataset 1 by pulling Table A from Source 1.
  • Created a Dataset 2 by pulling Table B and Table C from Source 2.
  • Created a Custom Dataset connecting Dataset 1 and Dataset 2.

Please see the above picture representation.

  • And now, I have created a relationship with Table B and Table A (Relation established).
  • While creating relationship with Table C again with Table A, its showing me an error as below

Table ‘Table B’ filters table ‘Table C’, which is from the same Power BI data source or Analysis Services data source, through a path that exists outside of the data source: ‘Table B’-> ‘ Table A‘->’Table C’.

 

My Questions:

  • Can we create multiple relationships from Table A to Table B and Table C on same dataset?

And please provide a solution on the error handling.

Please feel free to connect with me on any clarfications required.

Thanks,

Ajay

 

3 REPLIES 3
Anonymous
Not applicable

Hi Paul,

 

  • Dataset 1 (Pointing to CosmosDB) and Dataset 2 (Pointing to DataLake), both are Published in Service.
  • Custom Dataset was created by using published datasets.
  • I am using preview feature ‘DirectQuery for Power BI datasets and AS’ to convert LiveConnection to DirectQuery.
PaulDBrown
Community Champion
Community Champion

What is the structure of the "Custom Dataset"? What is the structure of Table A, B & C and what are their origins?

 

please follow the suggestions in this thread:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Hi Paul,

  • Dataset 1 (Pointing to CosmosDB) and Dataset 2 (Pointing to DataLake), both are Published in Service.
  • Custom Dataset was created by using published datasets.
  • I am using preview feature ‘DirectQuery for Power BI datasets and AS’ to convert LiveConnection to DirectQuery.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors