Forum Discussion
DJBadinN
5 years agoRegular Visitor
How do I pass Paginated Report Parameters using PowerBI-JavaScript powerbi-client?
1. How do I pass Paginated Report Parameters using PowerBI-JavaScript powerbi-client? I have Paginated Reports from SSRS. I opened the .rdl in Power BI Report Builder and Published to the Power BI S...
DJBadinN
5 years agoRegular Visitor
I am using dataset parameters, not dataset filters so the second link, Filters (Parameters) for RDL (Paginated) report in PowerBI-JavaScript API, will not work. In my scope, Filters are not acceptable due to performance issues as discussed Data retrieval guidance for paginated reports - Power BI | Microsoft Docs
The first link, Passing the configured parameter using the embed token, is a horribly convoluted and limited in scope hack. I did get it to work however:
- Testing does not work with
- Power BI Report Builder
- Power BI App Service
- Since it is not baked in, the workaround is not self documenting
- There is a Built-in Field for the Report, UserID (User!UserID)
- The Token Identity username maps to this Built-in Field
- If you need the actual Report UserID you cannot use this hack
- Does Not work if there are Multiple dataset Parameters
- Could pass a mult-value string in Identity username
- Parse UserID on Report side
- Doubtfully use other Identity Properties but are they mapped to Report Built-in Fields?
- datasets
- roles
- customData
- identityBlob
- reports
- Could pass a mult-value string in Identity username
- This is not an acceptable solution
todd_miller_nsi
3 years agoNew Member
Hi, I am also having this issue, have you came up with a solution?
Thanks!