cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
otravers Member
Member

Power BI RS authentication issues (works in browser on server, can't load from other PCs)

I'm currently setting up a client with PBI RS Server (I tried but cloud seems to be a no go), we use the August Preview both for the server and desktop (we upgraded from the June GA versions last week to try and avoid having to migrate the data mart to SSAS).

 

We're able to load data from both SSAS (where I've loaded data and a couple measures for test purposes) and regular SQL (which is our original data mart) into PBI RS Desktop. We then can publish both types of reports in PBI RS successfully (we've done so in two separate projects to keep things simple).

 

We're able to see the reports via the browser on the server, but not from other PCs on the same LAN. I'm a BI guy not an IT guy, so my networking knowledge is really basic. Kerberos, Active Directory, NTLM... please just shoot me! The fact I'm working remotely via TeamViewer doesn't help either, but anyway this is just outside of my expertise.

 

To help the local IT staff troubleshoot this, I want to doublecheck that I'm pointing them in the right direction. It's my understanding that PBI RS is a superset of SSRS. Does the following page apply to PBI RS? It doesn't say so explicitly so I'm not 100% sure this is relevant:

https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-windows-authentication-on...

 

The PBI RS admin handbook is rather sparse and seems to send you back to SSRS documentation after a while. I've already asked the client to test basic things such as the ability to ping the server and access a shared directory on it, to establish that the issue is not happening at a lower network layer.

 

We did add the user we're trying to connect with in the PBI RS admin security screen (/Reports/manage/security/browse). I see there's also a project-specific Administrate screen (/Reports/manage/catalogitem/security/nameofproject) which apparently inherits rights set at the server level, so I'm not sure it's necessary to create users here at this point (we're still testing things and I think there will be just one project in there for a while anyway).

 

Thanks for any help to troubleshoot this!

3 REPLIES 3
cmikos Regular Visitor
Regular Visitor

Re: Power BI RS authentication issues (works in browser on server, can't load from other PCs)

If Power BI Report Server is not on the same machine as SSAS you need to do this:

 

https://guyinacube.com/2017/02/configure-kerberos-power-bi-reports-reporting-services/

pmscorca Member
Member

Re: Power BI RS authentication issues (works in browser on server, can't load from other PCs)

Ok, but if does the issue occur also when PBI Report Server and SSAS Tabular are installed on the same machine?

 

Thanks

 

Errore Kerberos.png

cmikos Regular Visitor
Regular Visitor

Re: Power BI RS authentication issues (works in browser on server, can't load from other PCs)

No, you shouldn't get that error if PBIRS and SSAS are running on the same box.