Did you know that there is an easy way to run and extract Power BI REST API data?

The good news is that you can do this directly in your web browser. You don’t have to install or configure anything!

The method below works well if you want to either test the API to see what it returns.

Or if you want to run it to extract some data.

In the example below I am going to show you how I get a list of all the app users from an App that I have created.

This is the API that I am going to use to get the app users: Admin – Apps GetAppUsersAsAdmin – REST API (Power BI Power BI REST APIs) | Microsoft Learn

NOTE: The API above does require that I am a Power BI Administrator, which is highlighted below to show you the permissions required for the APIs

This is my App Audience and the users who have got access. I am going to compare this to the output from the API

I then went to the Admin API and clicked on Try It

It can take a few minutes to sign in, so please be patient when you see this below

I then continue with my account

I was then presented with the following screen below, where I need to get the appId

To get the App Id I went to my App in the Power BI Service

Now in the URL it will be the GUID (A bunch of numbers and strings after the /apps/ as highlighted below

I now put this into the AppId and now you can see the Request URL as shown below

I then click on Run

Once it runs, I can then see the output below, where I can both users also highlighted. This now shows me all the app users.

I can now see the output from the Power BI REST API directly in the browser.

Summary

In this blog post I have shown you how to get the output from the Power BI REST API directly in your browser to see the results.

This is a quick way to either see the output from the API or to get the actual information which might be required.

I hope you found this blog post useful and if you have any questions or suggestions, please let me know!