topic Re: Power BI Server and REST API calls in Report Server

Power BI Server and REST API calls

sato89 — Tue, 03 Jul 2018 15:43:42 GMT

Hi everyone,

I installed an instance of Power BI Server with some reports on a computer and I can view the reports in embed version inside a web-app by adding the parameter "?rs:Embed=true" to the report URL. I have also implemented the security integration with an ASP.NET web page that allow me to bypass the Power BI login and it uses customized credentials.

Now, can I also use REST API to get reports or dashboard from my Power BI Server? Note that my reports are on my Server and not on app.powerbi.com.

Can you helps me?

Thanks.

Best regard.

Salvatore

Re: Power BI Server and REST API calls

Anonymous — Tue, 03 Jul 2018 23:29:44 GMT

Hi,

Here's a list of supported REST Api for PBIRS: https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0

Hope that helps!

Re: Power BI Server and REST API calls

sato89 — Wed, 04 Jul 2018 09:50:43 GMT

Thank you shiboli for the answer.

For example I try to send this request:

<PBIWebServiceAddress>/api/v2.0/Session with appropriate headers and body.

I received 401 Unauthorized using Postman, but I have set the correct credentials according to the service account configured in the Report Server Configuration Manager.

What am I doing wrong?

Thank you in advance!

Re: Power BI Server and REST API calls

Anonymous — Tue, 21 Aug 2018 17:37:07 GMT

Hello sato89

You said that you implemented the securitiy integration to allow bypass the login and I´m trying to find a solution like that. Could you help me?

In my envirorment I have intalled the Power BI Report Server and I'm trying to embed the application in sharepoint and share it with external user authentication. Do you know if it´s possible to do it with the securitity integration that you mentioned

Did your configuration works?

Thanks

Re: Power BI Server and REST API calls

sato89 — Tue, 21 Aug 2018 21:11:20 GMT

Hi. Yes, my solution works very fine and I think that is good and works fine also for sharepoint reports encapsulation. You can try it! Did you have any problems?

Re: Power BI Server and REST API calls

sato89 — Tue, 06 Nov 2018 10:18:01 GMT

Can anyone help me abut this request? ;-)

Re: Power BI Server and REST API calls

Anonymous — Tue, 05 Mar 2019 23:49:06 GMT

Hi sato,

Have you managed to solved the problem?

Many thanks

Michal

Re: Power BI Server and REST API calls

subodhan — Thu, 12 Nov 2020 21:34:13 GMT

Let me know if you still have the issue open. If yes, I can help you go past where you are stuck.

Re: Power BI Server and REST API calls

shahirnana — Sat, 14 Nov 2020 17:35:25 GMT

Hi Sato89

I also face the same problem with the authentication, can you please share some info on this with me, really appreciated it

Re: Power BI Server and REST API calls

Anonymous — Mon, 14 Dec 2020 18:46:46 GMT

Hello Sato89,

I'm also working on the authentication side for my project. Would like to know how you managed to bypass the login. Could you please help, really aprecciated it.

Re: Power BI Server and REST API calls

eosorio — Thu, 30 Jun 2022 21:18:38 GMT

Hil, I have the same problem.

I am using Insomnia for test, but the result is 401 Unauthorized