Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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!
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/
Ok, but if does the issue occur also when PBI Report Server and SSAS Tabular are installed on the same machine?
Thanks
No, you shouldn't get that error if PBIRS and SSAS are running on the same box.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |