topic Re: REST API with API Key cannot connect or refresh from Report Server in Report Server

REST API with API Key cannot connect or refresh from Report Server

Anonymous — Fri, 06 Mar 2020 15:00:10 GMT

I'm creating a new issue for this, because the old one got marked as Solved. But it's not solved. Multuple people have confirmed it's still not working.

This was the original issue:

https://community.powerbi.com/t5/Report-Server/Data-source-is-Web-REST-API-when-will-refresh-be-possible-in-PBI/m-p/290116

Can someone from Microsoft please address this ASAP? It's, frankly, ridiculous that you can connect with an API Key from the Desktop but not from the Server. Thanks!

Jon-Heide - tagging you since you're the one that marked it Solved previously. Also tagging Anonymous since he recently commented on the old issue.

Re: REST API with API Key cannot connect or refresh from Report Server

Anonymous — Thu, 02 Apr 2020 16:59:25 GMT

Can someone from Microsoft please respond to this????

Re: REST API with API Key cannot connect or refresh from Report Server

dominicdanis — Thu, 02 Apr 2020 17:41:01 GMT

This is a request since 2017. Do you plan to fix it or not?

Re: REST API with API Key cannot connect or refresh from Report Server

Anonymous — Tue, 18 May 2021 15:17:37 GMT

So its 2021, and I still can't deploy a report to PBIRS because I can't enter the api key? This is an enterprise solution corrent?? Is there a workaround at least to get this working?

Re: REST API with API Key cannot connect or refresh from Report Server

Anonymous — Tue, 18 May 2021 15:33:31 GMT

It's unbelieveable to me that this is still an issue...

My only workaround has been to run a separate Python script, on a daily schedule, to pull down the APIs results into a JSON formatted text file. Then I point Power BI at that and pull in the data.

Pretty ridiculous.