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!PostgreSQL- Publish Error
I'm having an issue around published dashboard that connect to PostgreSQL that do not work. From my Power BI desktop, I can connect to PostgreSQL and build a (direct query) viz with no issues. I can even publish and get the "success" window. However, when I go to view the published dashboard, I get an access error about credentials. I have not modified anything on the PostgreSQL/ AWS side, but I'm wondering if there is something outside of Power BI that needs to be modified (maybe ralated to SSL)? Thank you. Thank you in advanced
