Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Employee
Employee

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

 

 

Anonymous
Not applicable

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.