Power BI Desktop (optimized for Report Server) allows you to define roles with DAX filters. However, when reports are published to the Report Server, there is no way to assign these roles to specific users/groups, so we can't yet implement row-level security on the Report Server. It would be great it Report Server was able to support dynamic row-level security similar to the Power BI Service.979 votes
We shipped this support in the January 2019 version of Power BI Report Server, which you can download here – https://aka.ms/pbireportserver
Thanks so much for all your votes on this idea!
It would be great if it would be possible to pass filters in the URL of the report on the report server (as it is already possible in Power BI online)285 votes
As promised, we’ve added basic filtering of Power BI reports via URL parameters, similar to the Power BI service feature described here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/.
For example, if you’ve embedded a Power BI report into another app using an iframe and a URL like the following:
Then you can specify additional filters using the “filter” URL parameter:
https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq ‘NC’ and Store/Chain eq ‘Fashions Direct’
Syntax: URL?filter=Table/Field eq ‘value’
The same restrictions that apply to the Power BI service apply to the Report Server as well:
- Table and Field names are case sensitive, value is not.
- Fields that are hidden from report view can still be filtered.
- Value has to be enclosed with single quotes.
- Field type has to be string.
- Table and field names cannot have any spaces.
At the moment it is only possible to save a Power BI report with data source Analysis Services to the Report Server. With any other data source you get a error, that only Analysis Services is supported. Please add the possibility to save reports with other data sources to Report Server.194 votes
With Power BI Report Server (October 2017), released earlier this week, you can now:
- Import data from any Power BI Desktop data source
- Schedule data refresh or connect in “DirectQuery” mode for many of the most-used data sources (see data source support: https://powerbi.microsoft.com/documentation/reportserver-data-sources/)
Thanks to all of you who tried the August 2017 Preview and shared your feedback!
The "Power BI Desktop" tool for Power BI Report Server looks pretty much the same as the standard "Power BI Desktop" tool.
Please rename it to something like "Power BI Desktop for Power BI Report Server".
Also, why not have an icon to represent it? Such as including a server symbol behind the Power BI icon?
I understand the need to have different tools due to the different release cycles therefore would be important to make the On-Premises version is more specific.29 votes
With the latest release of Power Bi Report Server, we’ve changed the icon colors for the Desktop version that ships with it to differentiate this from the version in the cloud service! Thanks for this great idea and we hope you like the latest release!
Currently File size to host on Power BI Report Server (on premise) is 100MB.
Please Increase the maximum file size to 2GB if possible.
1) I asked the question in the forum: https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-Excel-file-size-hosting-How-to-Increase/m-p/260648
2) For SharePoint 2013, we can do like ... https://blogs.technet.microsoft.com/sammykailini/2013/11/06/how-to-increase-the-maximum-upload-size-in-sharepoint-2013/11 votes
Thanks for your feedback! With the Power BI Report Server update released earlier this week, we’ve enhanced the report server to support upload and storage of much larger files, increased the default file size limit to 1 GB, and allowed you to increase it further to 2 GB if you like.
At the moment I can't save a pbix on the server, if the server is configured with a custom authentication (form). Even if it would be possible the live connection to ssas would not work because there would be no AD User behind the authentication. Additionally it would be necessary to define the ssas connection with a different (fixed) user.14 votes
Thanks for your feedback. The June 2017 release of Power BI Report Server does work with custom authentication extensions (the May 2017 Preview didn’t). Although Power BI Desktop doesn’t support this authentication method, you can save your *.pbix file to local disk and then upload it to the Report Server web portal.
(On this topic, while we support SQL Server Reporting Services-based custom authentication/authorization extensions today, we hope to invest in OpenID Connect/OAuth in future as a more modern approach to extensible authentication/authorization.)
It would be nice to embed directly from reports hosted on the new Power BI Report Server without having to publish to powerbi.com.1 vote
With the June 2017 release, you have a basic ability to embed a Power BI report stored in Power BI Report Server into another page or app via an iframe. Kasper de Jonge has a nice blog post on the topic: https://www.kasperonbi.com/embedding-power-bi-reports-with-power-bi-report-server/.
Need additional features for your embedded scenarios? (We know that might be the case.) Do submit ideas for specific features you need so we can see which ones are most important for the community. Thanks!
We need automated report deployment script similar to SSRS PowerShell or RS.exe utility for Power BI Report Server. This is critical for enterprise level change control process.12 votes
Check out the Power BI Report Server REST API (https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0), as well as the PowerShell sample on GitHub (https://github.com/Microsoft/Reporting-Services/blob/master/APISamples/powershell/powershellSamples.ps1).
Within Power BI Report server there is a download drop down menu in the top right corner of the page which offers options to download "Power BI Desktop", "Mobile Report Publisher", "Report Builder" and "Power BI Mobile".
There needs to be an option to disable these. Ideally at a granular level but at the very least the option to disable the actual drop down menu.
This would allow for a clean interface and the removal of options that our end users do not need and cannot actually use as they are not allowed to install applications.45 votes
We’re happy to report that we’ve added the option to hide the Download menu in SSRS 2017 (now generally available: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/10/02/sql-server-2017-reporting-services-now-generally-available/) and to our upcoming release of Power BI Report Server as well (targeting this quarter — Q4 CY 2017). Just set the system property ShowDownloadMenu=False (you can use SQL Server Management Studio to manage system properties).
We happened to be making an update to the Download menu, and with this feedback in mind, took the opportunity to add this option. As you can see, your feedback really does influence the product. Thanks!
Since PBI desktop has already released drill through function in Septemper's release, we thought it is such a wonderful design and it helps our work so much.
Could it be included in next release of On Premise PBI desktop and Report Server? Or how long would both desktop versions(vs report server) be consistent?
We really looking forward for this updates.3 votes
Good news: With this week’s update, Power BI Report Server now supports the drillthrough feature.
Identifying all the reports/dashboards used by a Data set, when the setting of a data source is selected in the web.
This would help identifying the impact on the reports if the dataset is deleted1 vote
Thanks for the feedback! In the web portal, you can view a list of other catalog items that depend on a particular data source or dataset; open the context menu for the data source or dataset, click “Manage,” and then “Dependent items.”
When I click on "manage" of a just uploaded Power BI report and try to change its name the message I receive is "something went wrong".
Internally, the log shows me:
2017-07-12 16:40:16.2748|ERROR|27|Unhandled error in the Web API|POST http://dashboard....api/reportproperties - Response Unknown| RequestID = s_f809758a-ffad-4c91-bc2b-12eb15751701 System.IO.FileFormatException: Archive file cannot be size 0.
Thanks for reporting this issue. We’ve fixed it in the current build of Power BI Report Server (download at https://powerbi.microsoft.com/report-server/).
SSRS is a mature platform with Microsoft. It'd be simpler and straightforward from the user's perspective to unify the solutions to render SSRS reports and Power BI on a single platform.
I mean a single "Report Manager"-like website that hosts and executes both Power BI and SSRS reports.4 votes
Power BI Report Server is now generally available (https://powerbi.microsoft.com/report-server/) and gives you exactly this — one modern web portal where business users can go to access both Power BI reports and SQL Server Reporting Services reports. And from an administrator’s perspective, it’s one server to deploy and manage; you can even migrate a report server database from an existing Reporting Services report server.
- Don't see your idea?