Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi Everyone,
I need some help with DAX Query. I am using Paginatedreports for PowerBI reports export functionality.
In PowerBI, I am planning to pass 3 parameters(multi valued parameters) in a URL for a PaginatedReport export .
Here is the query I generated using Query designer in paginated report.
EVALUATE SUMMARIZECOLUMNS(
'DealerDim'[OrganizationCode],
'DealerDim'[OrganizationName],
'DealerDim'[City],
'DealerDim'[State],
'InventoryFact'[TotalParts],
'InventoryFact'[TotalSKUs],
'InventoryFact'[InventoryValue],
'PartsDim'[PartNumber],
'PartsDim'[PartDescription],
RSCustomDaxFilter(@City,EqualToCondition,[DealerDim].[City],String),
RSCustomDaxFilter(@OrganizationCode,EqualToCondition,[DealerDim].[OrganizationCode],String),
RSCustomDaxFilter(@PartNumber,EqualToCondition,[PartsDim].[PartNumber],String),
)
Problem-
When a user selects All for @PartNumber the URL length is too long and erroring out.
So I am planning to send "ALL" value to @@PartNumber parameter when the user chooses SelectALL
Requirement -
So whenver I pass ALL value to @PartNumber parameter, I want following piece of line to be ignored or not executed RSCustomDaxFilter(@PartNumber,EqualToCondition,[PartsDim].[PartNumber],String), I tried to use IF condition and OR function. But nothing seems to be working for me.
Also, I see few articles suggesting to not to use Query designer in PaginatedReport builder to generate DAX query. Any input on that?
Any help with this is greatly appreciated .
Hi , @Jayasreeb
Based on my research and search, you can refer to this document for Query designer's query to specify limits to check if it helps:
Our team of engineers have also explained whether Query designer is not recommended or should be removed, you can check out this issue forum post:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
16 | |
10 | |
8 | |
8 | |
7 |