Testing Power BI REST APIs with Try it
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!
Thanks for detailed information, is there any way we can pass filters on report url e.g. if I have to test “Export to File API” (https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group) & need to pass filters – any idea if its doable using this “Try it” approach ?
Hi Khan,
From looking at the API it appears that this can be done using the “ExportFilter” parameter as part of the API call.
You would need to experiment with your data and fields to get this working as expected.
There is also new functionality that was released to keep your filters when sending a report subscription?
Subscribe to a report with filters applied
[…] Gilbert Quevauvilliers tries it: […]
Hi Bro I need Your help
Q1 : I am Using Mysql database in Power BI and In that DB in some tables they have entered logo Paths in columns
and i am concatenate the “http://185.230.209.209/util/” & [logo column] and given category as Image URL
when i place it in table visual it is not showing any images
Note : Previous they has given “https://somename.com/” when i am using this url means images are showing
but when above link applying means not showing any images
So, Please help me
Q2 : I have installed Power BI desktop and MySql workbench in Client Server
and when i open my Power BI Report in Transform Data it showing below error
” datasource.missing client library:we were unable to find a database provider with invariant name ‘Mysql.Data.MysqlClient’ ”
like that showing and also i have installed .NET and C++ also but no use still showing same error
Please give Reply to Questions
Thanks
Hi Saiprasad,
To your first question the server that is hosting the images has to be publicly available via the internet.
For your second question. I would suggest that you. make sure you are downloading the recommended version of my SQL.