Forum Discussion
Filters don't populate with values when using SQL data. Bower BI Report builder
Good Day, I am using Power BI report builder, as I want to create reports per category (voting wards in the City of Johannesburg in this case). I thus need to use filters. When I load the...
Ok, I see you need analysis server which is not available with SQL express. Will try a trial version of SQL or azure analysis server.
It's normal behaviour of SQL query designer. For example, SSRS designer in Visual Studio, which is mature tool then any others, also doesn't show up values for SQL queries. You have to manually provide values.
But this is not true for MDX/DAX queries. You can view all values and select.