cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shamsuddeenvp
Post Patron
Post Patron

Issue with accessing power bi reports in the service portal

Dear ,

 

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.

 

Thanks for your support.

 

Br,

SHams

Datasource.png

 

PBIReportServer.png

 

 

 

 

7 REPLIES 7
Jon-Heide
Microsoft
Microsoft

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

article: https://powerbi.microsoft.com/en-us/documentation/reportserver-configure-kerberos-powerbi-reports/

 

You could also, after publishing, store your user credentials in the server (which does not require the above steps). 

 

 

Thanks @Jon-Heide.

 

I tried to enter credentials in the manage and it works.. Did not set up kerberos now as just need to explore the features.

 

BTW, what is the need of kerberos? we have option login with this id and impersonate the id with user credential to access the data source. SO what is the use of kerberos?

 

Also Power BI report server can connect only SSAS still, read somewhere that it can connect many data sources

 

 

Br,

Shams

any help on the below queries?

 

BTW, what is the need of kerberos? we have option login with this id and impersonate the id with user credential to access the data source. SO what is the use of kerberos?

 

Also Power BI report server can connect only SSAS still, read somewhere that it can connect many data sources

 

Br,

Shams

Team,

 

Any input?

 

Br,

Shams

Hi Shams,

 

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.

 

Hth,

Rohit

 

 

Hi Rohit,

 

could be more accurate about "Kerberos setup is not needed when you store user credentials in the server"?

Do you say to use the path Data Sources --> Credentials --> Using the following credentials?

I think that when it is possible to avoid Kerberos constrained delegation it is better to do it.

 

Many thanks

Yes, you can use "Data Sources --> Credentials --> Using the following credentials" option to avoid using Kerberos.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.