Power BI Report Server
Support for new features of Power BI reports | General Availability | November 2018 |
Row-level security (RLS) | General Availability | November 2018 |
Export to Excel | General Availability | November 2018 |
Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi,
I've read that PBI RS is mainly a way to open PBI Desktop reports, and now i have a doubt:
when using PBI RS, the PBIx reports are opened on the local installation of PBI Desktop? Or does PBI RS have some kind of area to open PBIx files inside?
I haven't used PBI RS but i believe PBIx files are opened inside the local installation of PBI Desktop, and that also means that the user can:
- go to File menu and save as pdf, without any control from PBI Admin (if it exists?)
- does RLS work just as good as in PBI Service? i ask because if user has access to PBIx file, probably he can change the existing roles on PBIx file, right?
- To finish, is there any admin console, like in PBI Service, that allows the admin to prevent Exporting Data, Save to Pdf (as previously mentioned) and save as PBIx file (i don't think that this last one is appliable)
Regards
Solved! Go to Solution.
Reports are opened/viewed within the PBIRS portal, which a web application that ships with PBIRS.
You can set permissions for your users, which will disable their ability to download the PBIX and open it in PBI Desktop.
With regard to RLS, i believe this is a new feature of PBIRS August 2018, I haven't used it yet so can't comment.
Hope this helps.
RLS is only avilable on reports with Live Connections to SSAS Tabular models (which I have used) and on Direct Query to SQL Server Relational datasources (which I haven't used, only read about), the details of each are somewhat different.
RLS defined inside a PBIX is not currently supported, though I believe it is planned but when it might turn up I obviously have no idea. Using this form of RLS your users would indeed be able to alter the RLS if they had permissions to download and edit the PBIX file. You can limit them to just being able to view it using their web browser so most users would not be able to do so.
Reports are opened/viewed within the PBIRS portal, which a web application that ships with PBIRS.
You can set permissions for your users, which will disable their ability to download the PBIX and open it in PBI Desktop.
With regard to RLS, i believe this is a new feature of PBIRS August 2018, I haven't used it yet so can't comment.
Hope this helps.
Power BI is expected to be on next release of PBI RS.
November 2018
See roadmap here
October '18 summary of planned features for Power BI - Release Notes | Microsoft Docs
Support for new features of Power BI reports | General Availability | November 2018 |
Row-level security (RLS) | General Availability | November 2018 |
Export to Excel | General Availability | November 2018 |
RLS is only avilable on reports with Live Connections to SSAS Tabular models (which I have used) and on Direct Query to SQL Server Relational datasources (which I haven't used, only read about), the details of each are somewhat different.
RLS defined inside a PBIX is not currently supported, though I believe it is planned but when it might turn up I obviously have no idea. Using this form of RLS your users would indeed be able to alter the RLS if they had permissions to download and edit the PBIX file. You can limit them to just being able to view it using their web browser so most users would not be able to do so.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.