Forum Discussion
ldwf
Helper V
Helper VReport Builder - Pass parameter values to semantic model
I have a Report Builder/Paginated Report that connects to a published semantic model which points to a SQL Server database. The report prompts the user to enter in various parameter values (like fro...
I think I did not understand your need
Can you try the following steps (even in import mode, it should work)- Right click on the dataset for which you want to add some filters and select Dataset Propreties
You should have something like:
EVALUATE
SUMMARIZECOLUMNS(ColumnName...)
And replace it by the following code snippet
DEFINE
VAR param1 = @ParamName (Name of the first parameter you want to test)
EVALUATE
FILTER( TableName, TableName['ColumnToFilter'] = param1) - Link your parameter to the query, right click on your dataset --> Dataset propreties -->Parameters
and here pass the name of your parameter
- Run your query, normally it will ask to pass paramter BEFORE to generate the report
- Right click on the dataset for which you want to add some filters and select Dataset Propreties
ldwfHelper V
Helper VHi. The semantic model shows the Storage mode being 'Import' mode, not direct query. So this cannot be done in import mode? And how simple is it to change to 'direct query'? And where is the DAX query applied? Is it applied somewhere on the semantic model or on the Report Builder report? And there are other PBI dashboards that use the semantic model that are not parameter driven. Would those need changing?