cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hemingt Frequent Visitor
Frequent Visitor

How to bind two columns from two different tables

I am using Power BI service and I created dataset with push mode by REST API.

Now I have two different tables with same column 'Week', I want to create a report with the data from these two tables, the X axis is 'Week', but the Power BI service give the below error info:

 

" Power BI can't determine the relationship between two or more fields"

 

I want to create the report as below. How can I do? Thank you!

3.jpg

 

 

1.jpg2.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to bind two columns from two different tables

Hi there

 

Apoolgies the PBIX is the Power BI Desktop file and the format it is saved as is a PBIX

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
3 REPLIES 3
Super User
Super User

Re: How to bind two columns from two different tables

Hi there

unfortunately you are currently unable to create relationships between 2 tables using Power BI Push datasets.

You would have to import the data into a PBIX and then create a relationship between the data.
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
hemingt Frequent Visitor
Frequent Visitor

Re: How to bind two columns from two different tables

May I know what is PBIX? thank you!

Highlighted
Super User
Super User

Re: How to bind two columns from two different tables

Hi there

 

Apoolgies the PBIX is the Power BI Desktop file and the format it is saved as is a PBIX

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"