'Creating a slicer that filters multiple columns' solution from Marco (link) works great with Import storage mode.
Unfortunately, same desing based on DQ table (on Azure SQL Database) returns an error:
Incorrect syntax near ')'.. The exception was raised by the IDbCommand interface.
After reviewing generated query, it is clear that the search condition is missing in the last JOIN. There are only brackets after ON keyword at the end of SQL statement:
)
AS [semijoin1] on
(
)
)
GROUP BY [semijoin1].[c12]Query returns syntax error due to the missing code.
I was able to fix it in the management studio by adding missing part of the join and with that, query worked and returned expected values:
)
AS [semijoin1] on
(
basetable0.c10 = semijoin1.c10
)
)
GROUP BY [semijoin1].[c12]
I was using 2.85.985.0 64-bit version.
Cheers,
Raf
Comments
-
JoshT
on:
app.powerbi.com down?
-
DataZoe
on:
Set as landing page feature missing in Apr 2026 up...
-
RossEdwards
on:
Template App "Microsoft 365 Usage Analytics" faili...
- Tortitude on: No able to access Microsoft UI String Search page
- dcullen on: Gateway 3000.314.5 - Microsoft.Mashup.Container.Ne...
-
mattlee
on:
Input Text Slicer Broken on PBI Services
-
mattlee
on:
Input Slicer Bug: Cursor jumps to position 0 and v...
-
mattlee
on:
Input Slicer Causing Browser Tab Freeze in Public ...
- alisonmoraes on: Usuário PPU Sem acesso
-
mattlee
on:
Small multiples not fitting to scale