cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jtomczyk
Frequent Visitor

Error in Power Query / Merge queries

Hi, 

I have two queries. In first I have project numbers and many details related to the projects. In the second I have project numbers and requested ship date. I would like to bring that date to the first query. I used merge queries function (left outer).
While merging I got such error.

 

DataSource.Error: AnalysisServices: The argument value passed for Count was negative. Negative values are not supported for Count.
How to fix it?

Regards

JT

3.jpg

1 ACCEPTED SOLUTION
jennratten
Responsive Resident
Responsive Resident
3 REPLIES 3
jtomczyk
Frequent Visitor

Hi Jennratten,

I saw that post already. I have one sorting on the query (Line Amount Total USD). I cannot remove it as I have to remove duplicates of the projects and keep only the most expensive one. Do you know how to fix the issue with sorting? What creates issues on that step?

4.jpg

 

jennratten
Responsive Resident
Responsive Resident

Is sorting the only thing that happens in that query? Are there any other transformations performed?  If you could post your script that would be helpful.  There are some functions that perform internal counts and others that return internal negative values in the event no matches to a key are found.

 

If sort is the only transformation that is added, I recommend first removing the sort to see if that fixes the problem (to confirm whether or not it actually is the sort causing the problem) - then add it back.

jennratten
Responsive Resident
Responsive Resident

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.