Forum Discussion
Power BI Report Builder: Filter Table using a Multi-value parameter
Gangula wrote:Even if I switch off the "Design mode", the expression is a little different. It doesn't have a SELECT function, it directly starts with EVALUATE.
Query Designer
Hi Gangula,
The designer you're seeing relates to a SQL Server Analysis Services data source. These don't support transact-SQL (T-SQL). The connection type for your data source will need to be set to Microsoft SQL Server to work with the tutorial you've linked, e.g.:
The report builder is pretty much the old builder for SSRS (SQL Server Reporting Services) with a new skin, so I believe that most "old" guides should still work, albeit looking a bit different.
If you're using a SSAS/Power BI dataset and want to work with multi-valued parameters, either of the following may help, as the syntax will be different to T-SQL:
If you're using T-SQL for your dataset (I see you have some output in your repor, so looks like something is working), you'd normally add IN (@Parameter) to your WHERE clause and the tool will dynamically generate the SQL before running against SQL Server proper.
Hopefully this helps you out a bit. If not, you may need to share an example of the query you're running and the parameter setup so that we can help to build it for you if you're not sure.
Good luck!
Daniel