Forum Discussion
Paginated report parameters not filtering data
Hi Anotny ,
Is there any relationship created between the DIM table and FACT table in underlying data source side? It is required that it exist the proper relationship between the DIM table and FACT table. You can refer the following link to create and set the parameter for your paginated report:
A STEP-BY-STEP OVERVIEW OF PAGINATED REPORTS IN POWER BI
Paginated Report - Help With Parameters
I got this figured out. I had pasted the query for the paginated report from the Power BI desktop query in the performance analyzer. That creates a completely different DAX query than if you add your model and drag and drop your columns/measures into the query designer from scratch. Once I did this, the parameters were fine. I did have to include an "ORDER BY" at the end of the query because it doesn't alphabetize them.
Best Regards
Hi Anotny ,
Is there any relationship created between the DIM table and FACT table in underlying data source side? It is required that it exist the proper relationship between the DIM table and FACT table. You can refer the following link to create and set the parameter for your paginated report:
A STEP-BY-STEP OVERVIEW OF PAGINATED REPORTS IN POWER BI
Paginated Report - Help With Parameters
I got this figured out. I had pasted the query for the paginated report from the Power BI desktop query in the performance analyzer. That creates a completely different DAX query than if you add your model and drag and drop your columns/measures into the query designer from scratch. Once I did this, the parameters were fine. I did have to include an "ORDER BY" at the end of the query because it doesn't alphabetize them.
Best Regards