Issues with DAX dataset/query parameters in Power BI report Builder with live connection to SSAS

[AndriyK]

Hello,

i'm having intermittent issues with DAX dataset/query parameters in Power BI report Builder with live connection to SSAS.

i was able to build the custom dataset query with parameters and it is running fine in the report and i data is populated into the matrix visual.

but when i go to the query editor and trying to run it, i get the errors that parameter is not declared.

but it is declared and when i run the report, is runs without any errors.

i need to modify the query and add more fields, but i'm not able to view results in query editor in the Power BI Report builder.

Could you please let me know how i can fix it.

Thank you,

Andriy 

Query:

EVALUATE
CALCULATETABLE (
SUMMARIZECOLUMNS (
'Display Date'[CalendarYear],
'Display Date'[CalendarYearMonth1],
'Display Date'[CalendarYearMonth2],
"EBGPAY",
CALCULATE (
[EBGPAY Sum],
'Display Measures'[Display Measures] = "Display Calendar Periods"
)
),
'Date'[CalendarYearMonth2] = @DateCalendarYearMonth2,
'Employee'[Employee] = @EmployeeEmployee
)
ORDER BY 'Display Date'[CalendarYearMonth1]

[AndriyK · Accepted solution]

hi @Anonymous ,

thanks a lot for your reply!

The parameters were set up already. they are shown on the 3rd screenshot in my initial message.

i was expiriencing this issue all day yesterday, but today after the laptop restart everything is working fine.

looks like the issue could be related to my laptop, but not sure what was causing it.

Thanks again,
Andriy 

[Anonymous]

Hi @AndriyK ,
Based on your description and the provided screenshot of the error, I looked up the documentation for the issue in question, to add a parameter, click on the Parameters toolbar button in the Query Designer window. From here you can add the parameter name and default value.

You can refer to this document for more information

reporting services - The query contains the XXXXXName parameter, which is not declared. SSRS2008/MDX...

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly