Analysis services remotely or locally

Question

Hi there&nbsp;I got a report server with a local database and local analysis services which works fine.&nbsp;&nbsp;However, i'm trying to have a seperate report server and a seperate database server as a test enviroment, so two servers with this enviroment. I have installed analysis services and SQL server on the database server, the report server is running fine, however analysis services is not working when opening a directquery report.&nbsp;Now here comes the question, since i've installed analysis on the remote server, is this even going to work, if so, what am i doing wrong? Or do i need to have analysis services installed locally on the report server.&nbsp;Thanks!&nbsp;

d_gosbell · Answer

Now here comes the question, since i've installed analysis on the remote server, is this even going to work, if so, what am i doing wrong? Or do i need to have analysis services installed locally on the report server.This works fine, you just need to have Kerboros authentication configured in order to securely pass the user credentials between the report server and the remote servers.&nbsp;see&nbsp;https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports&nbsp;You just want to be slow and methodical when setting this up. But once it's up and running it works fine. We currently have both our test and prod environments configured this way.

dutchlimits · Answer

Ah! i've not seen this page before. I'll try it out. Thanks for the link.&nbsp;

Forum Discussion

Related content

Cohort analysis

Azure Analysis Service Migration Scenarios

Error Querying from Analysis Services Source

Retention analysis

Unable to Connect to Analysis Services from Power BI Report Server