cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmohanraja
Frequent Visitor

Login credentials not working on published report

Hi,

 

I have a report with a data connection to the Power BI API data (https://<ReportServer>/Reports/api/v2.0). The report works fine when saved in a local folder and refreshed. But when it is published on the on-premise report server, I am unable to get through the authentication. By default, "Anonymous" is selected, and that fails. The local folder version uses the logged in Windows users credentials, but the same Windows credentials fail for "Windows Authentication". I don't have values for the other authentication types. Please advise on how to solve the access issue.

 

Regards,

Mohan

 

nmohanraja_0-1628486929981.png

 

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@nmohanraja 

 

I am afraid you cannot use Odata source credential in report server. 

 

Please check the reply for Odata source in this thread.
Solved: oData Data Source Credentials issue - Microsoft Power BI Community

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

5 REPLIES 5
V-pazhen-msft
Community Support
Community Support

@nmohanraja 

 

I am afraid you cannot use Odata source credential in report server. 

 

Please check the reply for Odata source in this thread.
Solved: oData Data Source Credentials issue - Microsoft Power BI Community

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

FarhanAhmed
Super User
Super User

What error you are getting when trying to log in thru Windows Credentials? Can you please share the screenshot of it? Does the user has permission to access PBIRS server?

Also is it possible to check logs/events that are generating while trying to update credentials. 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




The user has access to the PBIRS server, and has connected to the Power BI Report Server homepage using the same credentials.

The error message:

nmohanraja_0-1628492613122.png

 

Make sure that you are using Domain\UserName instead of "UserName"







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Yes, I am using Domain\Username only.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.