This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hello,
We are testing Power BI Reporting Server. We want to be able to access the dashboards from the computers from the LAN connected to the domain. Currently we have are testing a SSAS data base. When the DB is on the same server as the Power BI Reporting Server, we are able to see the dashboards. When the DB is on an other server we have an error message:
Something went wrong.
We couldn’t run the report because we couldn’t connect to its data source. The report or data source might not be configured correctly.
With the following details:
We couldn’t connect to the Analysis Services server. The server forcibly closed the connection. To connect as the user viewing the report, your organization must have configured Kerberos constrained delegation.
We followed these steps https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports
But it didn't solve our problem completely. It doesn't work with "As the user viewing the report":
If I choose "Using the following credentials" and I enter manually any domain user and password, it works.
We are out of ideas. Where is the problem?
Thank you!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |