User Profile
roelverm
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Issue with CSS box sizing rule embedded report
Dear, When embedding my PowerBI report, the default CSS box sizing rule seems incorrect. See below screenshot of 1. My report on PowerBI server 2. My embedded report When checking the code in the browser, it seems to be related to this piece of code 'box-sizing: content-box' instead of 'box-sizing: border-box', but since it is inside the iFrame I can't change it. Any suggestions? Kind regards, RoelRe: Pass array in dynamic RLs with embedded report
Hi Anonymous , Thanks for your help, but unfortunately this does not do the trick. The numbers are not user ID, nor do I have a user table as this report will be embedded. I just receive a list of these numbers every time a users logs in via the source application and these numbers should filter the output school table Looking at the documentation I can only pass a single value, not multiples, but this seems strange as you can have multiple values using the IN statement but this is not compatible with the username() function. All other examples you provide seem to all work with a user table. If this is really the only way I could check to bring the user table over from the source application, but this seems data duplication and not ideal from maintenance perspective to keep it up to date. Kind regards, RoelPass array in dynamic RLs with embedded report
I have a PowerBI report embedded in a webapplication. Authorization and authentication is managed in a separate application and provides us with the information to generate the embed token. I have created a role called 'insitution ID' which filters the institution table based on the Id's which a user is allowed to see. This information is however not in my powerBI model nor do I want to recreate this in my model as this would create duplicate maintenance. Users can however have access to multiple institution IDs and this is where I can't get DAX to work as I can only pass a single value See example below { "accessLevel": "View", "identities": [ { "username": "12345" --> here I would need multiple values "roles": [ "InstitutionID"], "datasets": [ "fe0a1aeb-f6a4-4b27-a2d3-b5df3bb28bdc" ] } ] } See my dax formula I have tried using an IN operator, but this isn't compatible with the username() function It does work to have multiple values when I hard code Is there any way to pass on multiple institution IDs via the username() function or alternatives which don't reqiure me to have an additional table in my model linking the users with all possible institution numbers. Note that the amount of numbers could go up as high as 100. Many thanks
