PowerBI Report builder

homelander123, As you mentioned, the source is a semantic model connected to a dataflow, you cannot use SQL syntax. Paginated reports against semantic models use DAX queries. Here’s a detailed approach:

• Switch to text mode in Report Builder: In dataset properties, change from the graphical query designer to text mode. This gives you control to write DAX directly instead of relying on the designer’s auto‑generated query.

• Use DAX query syntax: All queries against a semantic model must start with EVALUATE. SUMMARIZECOLUMNS defines which fields you want to bring in. ADDCOLUMNS lets you add calculated measures. FILTER applies your parameters directly.

• Bind parameters manually: In dataset properties, map each report parameter to the DAX query parameter. This avoids cascading filters because parameters are applied independently in the FILTER clause.

• Reduce dataset size: Instead of pulling all 50+ columns, only include the fields required for the report layout. Use SELECTCOLUMNS or SUMMARIZECOLUMNS to keep the query lean.

• Leverage measures in the semantic model: If you already have measures defined, call them in your query rather than recalculating in the report. This pushes computation to the model engine.

• Test incrementally: Start with a small query (few columns, one parameter). Validate performance, then expand gradually. This helps isolate which parameters or columns cause slowdowns.