cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
homol
Advocate I
Advocate I

Dataflow refresh - cannot convert null to type logical

I have a Dataflow that looks good in the Power Query designer and appears to be in good order.  

 

However when I start the refresh, I get the following error:

Error Code: Mashup Exception Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: We cannot convert the value null to type Logical.

 

Does this mean that one of the values that its trying to insert into Dataverse is NULL or that something that appears to be functioning in my designer is actually erroring and I'm missing it?  Is that what a mashupexception represents?

1 ACCEPTED SOLUTION

Accepted Solutions

So it turns out that, in my case, the issue was actually within the designer mashup. And the Logical even made sense, once I figured.  I had a new conditional column in my final table, used for insert.  This conditional column was checking for a value to be greater than 0.  If it was it would set the value to one column versus another.  However in the column I was comparing, there happened to be one row out of 1400 that had a null value incorrectly.  This was generating an [Error] just within that cell for that row inside the designer but I didn't catch it.  Once I fixed the conditional, everything inserted fine.

View solution in original post

5 REPLIES 5
EricRegnier
Super User
Super User

Hi @homol,

Usually a mashup exception is when the data type is incompatible upon insert. It doesn't mean that if the PowerQuery designer work that it will work on import. For ex, you can have service-side validation, alt keys, etc, that might prevent the transaction. What destination column type is it, lookup?

well, it's hard to say, since I can't tell from the error dump, what is the affected column.  Or at least I don't think I can tell lol.  But yes, it's most likely a lookup that is a part of the key - that makes the most sense.  The "Logical" type is what was throwing me off - I started looking into my designer for True/False fields with Nulls lol.

homol
Advocate I
Advocate I

@EricRegnier 

Here's my particular setup:

I have an Investment table that has 2 different keys:

  • A combo key of 3 different lookups, to validate uniqueness (Internal Partner, External Partner, and Type)
  • An autonumber column that uniquely represents the Investment Code

I have a Tax Year table that has a Lookup to Investment - this is the table I'm trying to insert into - various years per investment.

 

My assumption was that I could simply get the autonumber value and associate it to my years and conduct my inserts.  I see this though in the Map tables screen.

 

Screen Shot 2021-05-20 at 8.18.01 AM.png

 

Does this mean that I still need to have the other 3 values to make the insert work?  I'm assuming that this is what's causing my error.

So it turns out that, in my case, the issue was actually within the designer mashup. And the Logical even made sense, once I figured.  I had a new conditional column in my final table, used for insert.  This conditional column was checking for a value to be greater than 0.  If it was it would set the value to one column versus another.  However in the column I was comparing, there happened to be one row out of 1400 that had a null value incorrectly.  This was generating an [Error] just within that cell for that row inside the designer but I didn't catch it.  Once I fixed the conditional, everything inserted fine.

Thanks for lettings us know!

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,678)