Forum Discussion
Solved
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!
Hi there
Apoolgies the PBIX is the Power BI Desktop file and the format it is saved as is a PBIX
3 Replies
- 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.
