Filtering Data In AnalysisServices.Database Source

Hi Vannikannan04,
Thank you for reaching out to the Microsoft fabric community forum.

To filter data at the source level from your Azure Analysis Services cube in Power BI, you can use Cube.ApplyParameter in Power Query to apply filters before expanding the cube, which enables query folding and improves performance. Instead of filtering after expanding dimensions, add the scenario and currency filters directly within the Cube.Transform step.

Check your filter values are correctly specified using the cube’s unique member names. To confirm query folding, right-click the transform step in Power Query Editor and check "View Native Query" to see if the MDX query includes your filters.

For dynamic filtering, create Power Query parameters for the scenario and currency values and reference them in the Cube.ApplyParameter function. If you encounter issues like invalid member names or no data returned, double-check the cube’s hierarchy structure or share any error messages for further assistance.

 
Best regards,
Ganesh Singamshetty.