topic Re: Power BI Report Server Authentication Issue - Azure AD Domain Joined Installation in Report Server

Power BI Report Server Authentication Issue - Azure AD Domain Joined Installation

NickColebourn — Tue, 01 Aug 2017 09:36:08 GMT

After a local installation of Power BI report server to a laptop which is ONLY domain joined to Azure AD (no on-premises domain join) the portal fails to load with the error message "Could not load folder contents"

This is the same /similar issue which affected SSRS for SQL Server 2016 at RTM and which was fixed in 2016 RTM CU2. Link to the similar issue here: https://support.microsoft.com/en-us/help/3171505/fix-the-service-is-not-available-error-when-you-use-ssrs-2016-portal-a

Config

Power BI Report Server Installed to it's default locations.

Web URL for the portal set to /ReportsPBI

Server URL for the portal set to ReportServerPBI

SQL Server installation is 2016 SP1 CU3 for the Report Server database.

Error message from the portal log is as follows.

RSPortal!library!RSPortal.exe!1a!08/01/2017-09:57:01:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.WindowsAuthz1355ApiException: , Microsoft.ReportingServices.Diagnostics.Utilities.WindowsAuthz1355ApiException: Windows returned a ERROR_NO_SUCH_DOMAIN error when Reporting Services attempted to call the Windows Authz APIs. If this issue persists Windows may be having issues connecting to the domain. Check the Windows Authz documentation for more information and details on diagnosing issues. Authz method: AuthzInitializeContextFromSid, Error code: 1355, UserName: AzureAD\UserNameHere

Does anyone know if this will be fixed in a future update as it was for 2016 SSRS in CU2 for 2016 RTM?

Cheers

Nick

Re: Power BI Report Server Authentication Issue - Azure AD Domain Joined Installation

Jon-Heide — Wed, 02 Aug 2017 21:42:14 GMT

Hi Nick - yes, unfortuantely the PBI Report server and SSRS both require a connection to an instance of Active Directory. The issue you noted for 2016 looks similar, however in that case the machine is still ultimately domain joined. One option you could consider is to install and run a local AD controller on your machine. Then use ADFS + Azure AD Connect to bind your local AD to AAD if you need to flow through your credentials for single sign on.

Native support for Azure AD as well as ADFS is a popular request. We're looking into it, but can't share any timelines at this point.

Re: Power BI Report Server Authentication Issue - Azure AD Domain Joined Installation

NickColebourn — Sat, 19 Aug 2017 07:10:03 GMT

Thanks for the reply Jon (and apologies for the lateness of the reply, not sure why the email notifications for this thread didn't work).

Installing an AD DC on a laptop will cause all sorts of support issues so it's not an option. Will hope to see support for Azure AD joined scenarios soon.