Report Builder - Issues with Paginated Reports Query Designer

[wrwillits]

I'm having an issue with PowerBI Repot Builder. I am trying to create a dataset using Query Designer and have added parameters so that the data being pulled is limited a specific date range. I need to generate a relative date range based on the last 90 days from when the report was run so the dates need to be relative to "Today()". I have tried various ways of generating this parameter, but nothing seems to work from within Query Designer (tried using the Range operator but that didn't seem to work). I then created a date counter in my PowerBI table thinking that I could just use a simple number in the Range operator and that would work (0-90). The interesting thing is that if I run it from within the Query Designer the data shows up correctly, but if I then go out and run the report to see how it will look, I get an error. I've also looked at the AQL query and it looks OK, and I click on the "Validate Query" that the message comes back that th validation was successful (I'm attaching screen shots of the messages). What am I doing wrong??

Here's what the query looks like:

EVALUATE SUMMARIZECOLUMNS('A_ Lease Schedules (2)'[Active Lessee], 'A_ Lease Schedules (2)'[Actual Event Date], 'A_ Lease Schedules (2)'[Advance/Arrears], 'A_ Lease Schedules (2)'[Aircraft (Serial #)], 'A_ Lease Schedules (2)'[Aircraft Type.], 'A_ Lease Schedules (2)'[Amount Received], 'A_ Lease Schedules (2)'[Amount Required], 'A_ Lease Schedules (2)'[Contract Due Date], 'A_ Lease Schedules (2)'[Contract Event], 'A_ Lease Schedules (2)'[Currency], 'A_ Lease Schedules (2)'[Default Interest], 'A_ Lease Schedules (2)'[Default Interest Rate], 'A_ Lease Schedules (2)'[Delay Days], 'A_ Lease Schedules (2)'[Event Detail], 'A_ Lease Schedules (2)'[Operator (Historic)], 'A_ Lease Schedules (2)'[Operator DBA.], 'A_ Lease Schedules (2)'[Owned/Managed], 'A_ Lease Schedules (2)'[Status], 'A_ Lease Schedules (2)'[Technical Status], 'A_ Lease Schedules (2)'[Transaction Status], 'A_ Lease Schedules (2)'[Variance], FILTER(VALUES('A_ Lease Schedules (2)'[Days Counter]), 'A_ Lease Schedules (2)'[Days Counter] >= VALUE("1") && 'A_ Lease Schedules (2)'[Days Counter] <= VALUE("90")), FILTER(VALUES('A_ Lease Schedules (2)'[Contract Event]), SEARCH("Rent", 'A_ Lease Schedules (2)'[Contract Event], 1, 0) > 0))

[garythomannCoGC]

Query Designer is a bug and should be removed/commented out 

Vote to have QD removed from the m$ code base.

[wrwillits · Accepted solution]

I have solved my own issue. What I didn't realize was that there were old parameters in the Parameters folder that were associated to older tables that had been deleted. Once I deleted the old parameters, the report ran.