Forum Discussion

CDavies's avatar
CDavies
Resolver I
6 years ago
Solved

OData issue using Power BI API

Hi [January 2020 Report Server and Desktop]   I'm working on the Report Server itself and have created a Report Server contents type of dashboard in the using several OData queries connecting to t...
Help required
  • CDavies's avatar
    CDavies
    6 years ago

    Final managed to solve this issue.

     

    I had to delete and re-add the SPNs for the ReportServer Service account.  The OData connectivity now works.

     

    Why?  Don't know but it works.

CDavies's avatar
CDavies
Resolver I
6 years ago

Hi

I've tried saving the connection and scheduling - same result

Checked the log files - nothing conclusive in there.

Developer tools (F12) in IE (yeah we're stuck with IE) gives this error in the response body:

{
  "@odata.context":"http://<MyServer>/PBIReports/api/v2.0/$metadata#Model.DataSourceCheckResult","IsSuccessful":false,"ErrorMessage":"Log on failed. Ensure the user name and password are correct."
}

Good point about the service account.  It's set up with a Domain/Username account not a Network Service account.  Not sure how to check the permission to authenticate part...

 

Thanks again for being a second set of eyes on this... 

 

d_gosbell's avatar
d_gosbell
Super User
6 years ago
CDavies wrote:

It's set up with a Domain/Username account not a Network Service account. 

 

That should not be the issue then. We normally use domain\username for our service accounts too. This means that the account should definitely be able to connect to your domain. (I think the service account would only be an issue if it was setup with LocalSystem or something like that).

 

Maybe you need to ask your domain admins, see if they can see authentication failures and help figure out what is going on here.

  • CDavies's avatar
    CDavies
    Resolver I
    6 years ago
    Ok, took a step back.

Test 1:
•Cleared All Permissions, and restarted PBI Desktop
•Odata connection to http://<myserver>/PBIReports/api/v2.0/Folders
•Windows Credentials: Use my current credentials
•Result: Success.  Data Returned

Test 2:
•Cleared All Permissions, and restarted PBI Desktop
•Odata connection to http://<myserver>/PBIReports/api/v2.0/Folders
•Windows Credentials: Use alternate credentials.  Used my Windows Domain\Username and password (should be the same as in test 1 right?)
•Result: Fail. 'We can't authenticate with the credentials provided'

Log files are no help, Event view doesn't capture anything, may bounce the serve
  • CDavies's avatar
    CDavies
    Resolver I
    6 years ago

    Final managed to solve this issue.

     

    I had to delete and re-add the SPNs for the ReportServer Service account.  The OData connectivity now works.

     

    Why?  Don't know but it works.