How to access a Power BI report Server sheet
Hi, I have a Power BI report server URL which has 4-5 sheets. Is it possible to access any of the sheets using a URL? I am trying to automate a process which involves going to the Power BI Report server URL and downloading that sheet manually and then uploading it into a system that can accept URL as an input.
db_owner & dms$system.UserQueries
Is it possible to access the db_owner role of a datamart database through SSMS? Even as an admin_user there is no permissions to grant, no extended events and some restricted tables Additionally is it possible to query dms$system.UserQueries? the schema seems to be restricted by default
Allow external users access to Reports one Report Server
My firm uses PowerBI Report Server. I haven't seen any updates on this so I'm thinking no, but want to confirm: Are external users allowed to access reports on the Report Server without being on premisis (with RLS) Can we embed powerbi reports (via iframe) within our secured website that that clients can log in to (again with RLS maintained)? Thanks, Sheila
Power BI Page "does not exist"
Hi, Guys. I have ain ssue with just one users. He is clicking the link to access Report Server but receives the message below (<ServerName> is the name of the page in Report Server. Again, accesible by all the rest of the users). The configuration of the laptop is the same as anybody else and the security is the same. Report Server is up to date. Any idea why this is happening to this user? Thanks ina advance.
RLS-modelling with several roles and filters to access Facts
Hi, I've been struggeling for a few weeks with my PBI-model. I have a solution that is working today, but it completely killed the performance of the report. So I need to find another way around my issue, and some dynamic RLS might be the way to go. I have a LinkTable which contains LinkTableId to connect to the FactTables. Each LinkTableId has ActivityAdminId, ActivityBrokerId, ResponsibleAdminId, ResponsibleBrokerId (different roles/people/users that are related to the specific row in the facttable). This is 4 different people/users (the same user could have all 4 roles at the same time on the same LinkTableId). What I need is to filter the linktable based on which user is using the report. I've written this RLS-DAX-code on my LinkTable: [ResponsibleBrokerId] IN CALCULATETABLE ( VALUES ( 'AccessTestTable'[BrokerId] ), FILTER ( ALL ( 'AccessTestTable'), [UserPrincipalName] = USERPRINCIPALNAME() ) ) || [ActivityBrokerId] IN CALCULATETABLE ( VALUES ( 'AccessTestTable2'[BrokerId] ), FILTER ( ALL ( 'AccessTestTable2'), [UserPrincipalName] = USERPRINCIPALNAME() ) ) So far all is good. Now in my model, each use can have different type of access. The user should in some context have access to other users. This is today handled with a filter on the whole report (or a specific page / data), which comes from my Access-table: I've been trying to adjust my RLS-DAX to use this information, but so far it doesn't care about my page/report-filter - something like this. It did work if I replace "IN CALC...." with just = 1 (the value, but then it's not dynamic as I want it) Summary of my needs: The user should have access to all linktableids where the user has any of the 4 roles (ActivityAdminId, ActivityBrokerId, ResponsibleAdminId, ResponsibleBrokerId) I need to be able to filter specific reports / pages based on "Mentorsrad" so that a user can only access the data where AccessTestTable[Mentorsrad] = the chosen value I also want to be able to filter so that the user can choose "Now I only want to see rows which I have access to based on role ActivityAdminId" (Any of ActivityAdminId, ActivityBrokerId, ResponsibleAdminId, ResponsibleBrokerId) Todays solution (in case someone can figure something smart out from this) RLS on DimAccess. AccessToLinkTable contains all LinkTableIds each BrokerId should have access to. But this table is like 25m rows, so everything gets super slow. Any help is appreciated! If you need any more details of my model, just ask and I'll try to answer!Banned user from community
One of our PBI company users reached out to me asking for help. She used to visit this community in past when looking for help but recently, whenever she access the site either directly or via google, she just gets a message that she's banned. She's not aware of doing anything wrong, she did not signed in (so it's not her community account being banned) and we don't know where to look for a help. Nobody else from our company report this problem, only her. I doubt this is for MS Premier support, so I'm trying here with hope someone from community will be able to help? Thanks!
