custom security sample
4 TopicsAccessing the power BI on public domain
Hi We have a requirement where we have to configure the Power BI solution outside the company domain. Now my problem is if I host the solution, then my partner companies users cannot access the reports because they are not part of the company domain. So PowerBI will not allow the users to access the reports. After investigation, what I have learnt is there is a custom security sample developed by Microsoft which handles such a situation. In a development environment, everything is working fine using that custom security component. However, when I wanted to host these reports in the production, it failed other applications who are also having access to Power BI reports. So my question is, how can I make my reports accessible to internet users without having domain authenticationSolved2.2KViews0likes2CommentsPBIRS (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.7KViews0likes6CommentsSSAS live connection string property and DAX CustomData()
Hello, This might be an old question but maybe changes/updates have changed the answer. Based on some articles below - it looks like dax function CustomData(https://docs.microsoft.com/en-us/dax/customdata-function-dax) will retrieve the CustomData property of the connection string in SSAS on premise. https://www.kasperonbi.com/using-customdata-and-ssas-with-power-bi-embedded/ https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/06/03/passing-user-names-to-analysis-services-wi... SSRS passes the {{USERID}} values into the connection string on connection - does PBIRS function the same way when an authenticated user opens a report with CustomData={{USERID}} in the connection string on the report server webpage? If there any particular function or method found in the custom forms authentication example on github that would be crucial to the resolution of this value? Would SSRS or PowerBIRS be invoking GetUserInfo()?3.1KViews1like2CommentsHow to use REST API from PBIRS with Custom Security authentication
We've implemented an updated version of the CustomSecuritySample to handle authentication for our on-premises Power BI Report Server. I'd like to be able to automate some management tasks, including publishing an updated PBIX file to multiple folders and updating their data sources, but I can't seem to get past authentication with the REST API in C#. Has anyone else done this? Are there code samples available?3.5KViews0likes2Comments