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.

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

Hi

Yes: Domain\Username

Username has db_datareader on the PBIReportServer DB and local admin rights on the server itself.

So if you are using the OData url that user does not need any driect rights on the PBIReportServer DB or the server itself. 

 

It's not entirely clear where you are getting is error from. I'm assuming that you have successfully uploaded your report to the server and you are getting this error in the Manage > Data Sources page - is this correct?

 

What authentication option have you chosen - it should be "Windows Authentication".

 

I just double checked this on my server and using Windows Authentication and the Domain\Username format worked for me and I was able to schedule a refresh against the http://<MyServer>/PBIReports/api/v2.0/Folders endpoint. 

CDavies's avatar
CDavies
Resolver I
6 years ago

Thanks for looking/taking an interest...

 

Yup, using Windowss Authentication, and getting the error from the Manage > Data Sources > Test Connection. (I'm copying and pasting the password from our password manager which works successfully with SQL queries...)

 

Curiously though if I copy the OData url directly into the browser address bar, it correctly gives me the .json file to download.