Forum Discussion

wildcatstar's avatar
wildcatstar
Icon for Helper I rankHelper I
9 years ago
Solved

How can I remove auth page when open Report Server page?

Hi,     I try to use Power BI ReportServer in LAN.     Everything goes well except when I open  the report on ReportServer there always prompt a login page。     So how can I remove it？Hard code th...
Auth
  • asogukpinar's avatar
    asogukpinar
    9 years ago

    Solution for the exception that is taken for power Bi reports while using custom security extension :
    *****************************************

    2017-08-03 11:35:16.8710|ERROR|90|Failure in conceptualschema| RequestID = 5a55046e-0305-361b-e214-71fd8b0d79ff ClientSessionID = 3aee7b14-c24b-d6ac-237d-38809550b1bb System.NotSupportedException: PortalIdentity is not supported.

       at Microsoft.PowerBI.ReportServer.ExploreHost.UserIdentityConnectionImpersonatorFactory.CreateImpersonator(IIdentity identity)

       at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.GetModelInfo(String id)

    ***********************

    The data source attempting to use integrated security which is not supported with custom Auth. If you edit the data source for the report and use stored credentials it should work.

     

muchinski's avatar
muchinski
Icon for Resolver II rankResolver II
9 years ago

Hi wildcatstar

 

Maybe I got it wrong due to many development answers, but did you tried just to add your site on the local intranet on Internet Properties screen?

It could be an problem regarding to NTLM on you LAN. If you windows, for any reason, don't reconizes that it is a LAN address, it is going to ask for auth (so far as I know)

 

wildcatstar's avatar
wildcatstar
Icon for Helper I rankHelper I
9 years ago
Hi muchinski , I just have tried this way, it will only work when open the server from ie on the server computer, when open  from other computer,it still need auth .
  • muchinski's avatar
    muchinski
    Icon for Resolver II rankResolver II
    9 years ago

    Hi wildcatstar,

     

    Yes, I meant to do that on all user computers, OR don't use IP address to access the reports, OR don't use FQDN.

    I think that if you change the Authentication method, maybe you will fall in problems with SSAS connections, because SSAS accept only Windows Authentication (NTLM (default) if in the same SSRS machine or Kerberos  if SSAS is in a remote server)

      

    Please, read this article: https://support.microsoft.com/en-us/help/303650/intranet-site-is-identified-as-an-internet-site-when-you-use-an-fqdn-o

     

    :smileyvery-happy:

    • wildcatstar's avatar
      wildcatstar
      Icon for Helper I rankHelper I
      9 years ago

      Hi muchinski,

         I have read the artile, and I don't think it is a proper solution to require user to change the IE config.

         In that way, maybe input username and password is more easier.

         If custom auth is not supportted by SSAS connection, may be I have to wait until the report server support embed data,

         just like excel,etc.

      • muchinski's avatar
        muchinski
        Icon for Resolver II rankResolver II
        9 years ago

        Hi wildcatstar,

         

        I am not telling that it is not supported, you could just use a fixed user in a SSAS connection and that’s ok, but usually we use Windows Authentication. Also, you would need to validate it before every update, which for me is not a good deal.

        Anyway, just to clarify (I just tested - and it is the same that the article said): It will ask for authentication if I access the reports using:
        -- FQDN - http://inhouse-rep1.<MyDomain>.de/Reports
        -- IP - http://50.52.41.23/Reports
        But if I access using a URL like the following or add the site on Local Intranet, windows authentication works as expected (at least for me)
        -- http://inhouse-rep1/Reports

         

        I hope to have helped :)