Forum Discussion

CDavies's avatar
CDavies
Icon for Resolver I rankResolver 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.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

I'm struggling to think what else we can try.

 

There is a long shot that this might just be a bug with the "Test" button, so maybe try saving your credentials anyway as a temporary test (since we know your account definitely gets the expected json result) and see if you can then run a scheduled refresh.

 

And the other thing that is worth checking are the PBIRS logs, maybe they might have more information that will give a hint as to why this is not working.

 

It's also worth checking how the service account for PBIRS is configured - is it using a domain account or something like NetworkService which would have permission to authenticate accounts against AD?

CDavies's avatar
CDavies
Icon for Resolver I rankResolver 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...