Forum Discussion
Unexpected Error - A Tasks exceptions were not observed
Hi Guys, sorry I'm pretty new at this, but I've come across this error when trying to create a relationship between 2 tables... I've tried restarting and tried creating a new pbix, neither changed...
doubtful on the unique values
added a table to match up transaction dates to the week number that it falls in, linking the data table to the "week number" table causes the error... date-types match in each table, range of dates in the created table goes both before and past the transaction dates in the other table...
all good, have sent a "frown", cheers ;)
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi twittrer,
If you want to create a relationship between 2 tables, at least one column in one of the tables must contain unique values. There are only many-one and one-one relationship in Power BI. More details, please review this article: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.
Best Regards,
Angelia