Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
twittrer
New Member

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 the outcome... does anyone have any advice they could offer please and thank you?

 

power bi error message.JPG

9 REPLIES 9
kgosalia12
Frequent Visitor

I was facing a similar issue. I was working on Virtual Machine - after restarting/rebooting the machine and upgrading to the newest version solved the problem for me. Hope this helps! 

Anonymous
Not applicable

I am getting the same error. The 2 tables are on the Azure SQL cloud.

One of the tables has the PK unique values for the 1:m relationship. 

Anonymous
Not applicable

I am getting the same error. The 2 tables are on the Azure SQL cloud.

One of the tables has the PK unique values for the 1:m relationship. 

Anonymous
Not applicable

I'm getting the same error, version December 2018.  Anybody have an answer yet?

bathnesresearch
Regular Visitor

Yup, getting this one too. This was for a 1:many relationship from a summarised table. 

 

 

Copied to csv and there were some very odd behavours, including some characters which absolutely weren't in the raw data - bodged a text file together for this purpose and added it as a completely new table and it's behaving normally.

 

This was fine as we're just prototyping, but this will be a real pain if it is persistent

 

Greg_Deckler
Super User
Super User

Wow, 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?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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 😉

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors