Forum Discussion
SSAS DNS name not working from Report Server:
Hi,
I am able to connect to my SSAS Instance with DNS/Alias name from SSMS and Power BI desktop.
But once report is published to report server, it fails to render data. And when i modify the connection string to acutal server name(instead of DNS name), it works well.
I cant as my power user to change the connection string for every report they publish.
PBIRS version is May 2019 and SSAS Tabular is 2016 SQL Server.
Please suggest if there are any fixes to be done here.
Thanks
Manoj
7 Replies
Are your Power BI Report Server and SSAS instances on separate machines? If so you probably have a Kerberos configuration issue.
SSMS and Power BI Desktop can fall back to using NTLM authentication as they only do a single "hop" connection
Client --> SSAS Server
But if Power BI Report Server is running on it's own server (which is a best practice) then you have the following:
Client --> Report Server --> SSAS Server
Where each of the arrows (-->) is a network hop and NTLM can only do single hop scenarios, for more than one network "hop" you need to have Kerberos configured and the SPNs and constrained delegation settings need to be setup with the correct name. It sounds like you might have these configured using the server name, not the DNS name.
Hi d_gosbell
Thanks for your response.
SSAS instance and PBIRS are on same server box.
I will check if Keberos delegation is setup for this use case. If now will follow documentation and set it up.
Thanks
Manoj
No, if the two services are running on the one server Kerberos is not your issue.
What error do you get when using the DNS name?
If you log on to the server can you ping the DNS name and does it resolve correctly?
