Forum Discussion
QUERY ISSUES: Expression.Error: We cannot convert the value null to type Logical.
Hi Folks, I know this has been asked loads before and I have read the threads but nothing is working for me.... I have 2 tables pulling from Salesforce Objects, a Header Table and a Product Table...
Do the queries get created at all in Power Query? If so, what do the Applied Step(s) look like?
Hi Natel,
Yes within the query editor it all looks fine it only fires the error if I either:
Load the tables fully
or
If I try merge my 2 tables within the query editor.
I do have a good number of steps on my headers table including merging to other tables numerous times for account names etc.
Come to think of it though my problems did begin when I added a Conditional Column to the query of if column Disti contained "PARTNER" then "Y" else "N".
It might be coincidental though?