Forum Discussion
OData issue using Power BI API
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.
Yeah, it's a puzzle...
I get the same error using my domain/user login credentials in the test connection box, which is why it's confusing that the .json file downloads from the browser.
My user account is in an AD Group with Content Manager rights on the whole PBIReport Server.
May have to get the SQL team to SSIS these queries into a db rather than using the api... which would be a shame.
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?