Forum Discussion
Unexpected Error - A Tasks exceptions were not observed
Community ChampionWow, that's a unique error. I'd send a frown. Do you have unique values in one of those tables? Are the columns the same data types? How many rows are we talking?
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-msftMicrosoft Employee
Hi 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- v-huizhn-msft
Hi twittrer,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here. Please feel free to ask if you still have other issue.
Best Regards,
Angelia
