Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Service. The reports use Direct Queries and have Parameters.
In the Power Bi Playground, I can use the URL Parameter rp, "&rp:Company=ABC", to pass parameter values to the Report.
Using PowerBI-JavaScript, if add the URL Parameter in the config embedURL, "&rp:Company=ABC", it does not work.
I have looked at Filters but I understand this is different from Parameters where Parameters limit the data returned from the Data Source where Filters work on the Data returned from the Data Source which can be inefficient with a large amount of data.
2. Where can I find documentation on the life cycle flow I should expect to see?
Using Fiddler, I see a bunch off calls to wabi-us-east-a-primary-redirect.analysis.windows.net with an origin of https://app.powerbi.com/.
Upgrading did not help:
- Microsoft.PowerBI.API 3.21.0 to 3.23.0
- PowerBI-JavaScript 2.16.5 to 2.18.0
Hi @DJBadinN ,
Sorry I didn’t find a official document or blog for your question. Please check the link below, hope they can help you and give you some clues or ideas.
Passing the configured parameter using the embed token
Filters (Parameters) for RDL (Paginated) report in PowerBI-JavaScript API
Best Regards
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:
Hi, I am also having this issue, have you came up with a solution?
Thanks!
Hi DJBadinN,
I managed to embed a simple paginated report using embedded dataset, but for POC I would need to pass some filters as well as I need to explore the capabilities of applying RLS. I defined a Built-In-Field UserID as filter (at this point I am not concerned about performance, and eventually can rework this as parameter).
Can you please help with hacking the call to GenerateTokenRequest API? Per MS documents, this is how the body is supposed to look like:
I came up with this using C# sample:
However, EffectiveIdentity method does not have a parameter 'reports' so I am guessing it shouldn't be used at all?
I am picking up C# on the spot hence struggling with coming up with a custom solution, and any suggestion/hint would be greatly appreciated!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |