Forum Discussion

lg1551's avatar
lg1551
Resolver II
3 years ago
Solved

Paginated Report - Help With Parameters

I have a basic table from a PBIX which I have brought into a paginated report that I created in Report Builder in the Power BI Service. I have now linked a paginated report visual to that report in t...
Need Help
  • lg1551's avatar
    lg1551
    3 years ago

    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.

lg1551's avatar
lg1551
Resolver II
3 years ago

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.