pbirs on premise
12 TopicsData source changed to chinese
All connection strings for Dashboards on Power BI Report Server have been changed to Chinese, and no longer work. This has already happened several times and the restart of the server helped before. But now restarting does not help. Power BI Report Server of Version1.12.7936.39665(September 2021)2.4KViews2likes5CommentsCalculation groups with PBIRS
I understand it may be possible to create calculation groups in PBIRS reports but can't find how you can connect to the data model from Tabular Editor. This thread https://community.powerbi.com/t5/Report-Server/Create-Calculation-Group-in-Power-BI-Report-Server/m-p/1494565 says you can do it by enabling enhanced metadata format, which was a preview feature some time ago but I can not see any option for now int he Sept 2021 desktop client. Is it possible to create calculation groups for PBIRS, and if so how? Thanks LeslieSolved1.7KViews0likes3CommentsPBIRS Web Analytics
My environment an on premise PBIRS, running many .pbix and .rdl reports. I need to monitor which reports is mostly used by users. I added Google analytics in my "C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\Pages\ReportViewer.aspx" file and works for .rdl files, but not to .pbix. When a .rdl file is open, google script is able to capture trafic, this not occurs with .pbix files. How can I use a web analytics for my PBI portal ?1.1KViews0likes2CommentsPBIRS (March 2018 release) with custom security sample - error
I'm trying to configure the March 2018 PBIRS release to use custom authentication. We have the October 2017 release working fine, but need to move to the latest version. If I customize the March 2018 release with the default configuration as specified in the ReadMe.md, it works properly. I can register new users and log into the PBIRS server through the logon.aspx page. However, our forms authentication requirements are a bit more complicated than that. We are displaying embedded Power BI reports in our existing form-authenticated application, so rather than using the default PassThroughCookies specified for rsreportserver.config, we use the following: <PassThroughCookies> <PassThroughCookie>.ASPXAUTH</PassThroughCookie> </PassThroughCookies> Similarly, in web.config, instead of the "forms" configuration with "logon.aspx" and "sqlAuthCookie", we point to our application login: <forms timeout="120" domain=".productiondomain.com" cookieless="UseCookies" enableCrossAppRedirects="true" name=".ASPXAUTH" loginUrl="http://formsLogin.productiondomain.com" /> The server seems to start properly, with no errors in any of the log files -- until I attempt to access the PBIRS portal (https://pbirs.productiondomain.com/Reports). The access attempt results in an HTTP 500 error on my browser, and the following error in the RSPortal log file: 2018-06-20 16:33:17.4985|ERROR|5| 192.168.32.221: GET /browse/ - 0:00:00.0315727 Exception: System.Web.HttpException (0x80004005): Unable to validate data. at System.Web.Configuration.MachineKeySection.EncryptOrDecryptData(Boolean fEncrypt, Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Boolean useValidationSymAlgo, Boolean useLegacyMode, IVType ivType, Boolean signData) at System.Web.Security.FormsAuthentication.Decrypt(String encryptedTicket) at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.CreateRequestContextFromCookie(IOwinContext context) at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.CreatePortalIdentity(IOwinContext context) at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.Invoke(IOwinContext context) at Microsoft.Owin.Security.Infrastructure.AuthenticationMiddleware`1.<Invoke>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.BIServer.Owin.Common.Middleware.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext()| RequestID = s_8746993e-6fe4-4a0d-84d3-ff0d3256c9cc With the October 2017 release of PBIRS and the old version of the CustomSecuritySample, things worked just fine. Using the March 2018 release of PBIRS with either the old version or current version of CustomSecuritySample with our additional customizations fails.Solved5.8KViews0likes6CommentsPower BI Jan 2019 Development Environment
Gday, At our site, saving a report in Jan 2019 PBIRS (on prem) will make it unusable in August 2018 PBIRS. Is this a known issue? If so how are people managing a 2019 dev environment while still running a 2018 live environment? Id like to have a number of users testing the 2019 release before deployment but this seems like a massive problem now because reports are not movable between the two environments. Any tips? Cheers942Views0likes2CommentsPBIRS Security Roles for adding to favorites
I have configured PBIRS with custom secuirty and by default give all users who authenticate Browse role to the home page. Unforturnately they cannot set reports to favorites. I want to create a custom Browser role and add the ability to add a report to their favorites but I cannot find out what box to check. Below are default setting for the Browser role in PBIRS. Which one(s) should be selected to allow a user to add a report to the favorites?791Views0likes0CommentsPBIRS August Update - Security Question
Hi We have folder security in operation on PBIRS. Each folder can contain some Paginated Reports, Power BI reports and Excel workbooks. Security on the folder is maintained via AD Groups which is assigned Browser privileges on the folder. This enables the Users to view/acces each of the folder contents, however since the August update, Excel workbooks no longer download when clicked. Paginated and Power BI reports operate as normal. For the Users to access/open/download the Excel workbooks security on these files needs to be customised and elevated to Content Manager. Has this change in security changed by design or by other reasons? Is it only me or are there others experiencing the same? Thanks2.7KViews2likes5CommentsPower BI Desktop (RS) with Custom Security?
Hello Power BI Community! after successfully applying the changes that needs to be done for the Custom Security sample from github (https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample) I've created new accounts in the database and everythins works fine when logging into the webpage http://<server>/reports. Power BI reports can be executed without problems but from Power BI Desktop (RS) there is no chance to open or save reports. The Error Message is in the connection dialog to the Server: "Unexpected error encountered" Before applying the changes for Custom Security everything works fine. How can I fix this? Thanks and best Regards Volker1.3KViews0likes1Comment