Issue with accessing power bi reports in the service portal
I am facing an issue with accessing the power bi report on report server from my desktop system, it throws error as in the screenshot. However same url is accessible in the server. Both the server and my machine are on the same network. I am able to access the report server url without no issues. issue only when i open the report.
I am able to access the report in PBI desktop from my machine, but not in via report server url.
Also I read in blog that now Power BI server support other data sources as well, however I am still getting the same issue. Installed the latest report server only.
You are likely hitting a security feature of windows authentication, called double-hop. This requires a domain configuraiton which authorizes the report server to "act on your behalf" to connect to the data source. Take a look at this
You had 2 questions mentioned in your original post. Trying to address them individually -
1. A "double hop" issue is one where your windows credentials have to flow through two separate connections. In your case, when accessing the URL from your desktop system, there is one connection to the Power BI Server and then the second connection is from Power BI Server to your AS data source. Kerberos enables this scenario by letting your creds flow through to the second connection. You can read more about this by searching online. As Jon mentioned earlier, Kerberos setup is not needed when you store user credentials in the server.
2. Power BI Report Server August Preview supports other data sources. You need to use the updated Power BI Desktop as well for this. Please download the newer Desktop using Power BI Report Server web portal's Download menu in top toolbar.