How to bind two columns from two different tables

[hemingt]

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!

[GilbertQ]

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.

[hemingt]

May I know what is PBIX? thank you!

[GilbertQ · Accepted solution]

Hi there

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