Forum Discussion
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...
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.
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 serveFinal 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.