topic Re: Authenticate REST API in Developer

Authenticate REST API

Tweeg — Sat, 07 May 2022 16:41:54 GMT

It looks like changes were made to the REST API.

The 'Try it' function from the page is gone so I tried do do it myself using Postman.

When authenticating with my service principle, a lot of API calls give me the following response: "Message": "API is not accessible for application".

So I have been trying to authenticate with my personal (admin) account, but how to do this is nowhere to be found in the documentation.

I found a workaround (open the PowerBI service in Chrome, then open a workspace and take the bearer token from the Developer Tools in chrome). But that can't be the way.

Re: Authenticate REST API

Anonymous — Tue, 10 May 2022 03:15:42 GMT

Hi @Tweeg ,

Actually, it is a known issue. The Power BI team is aware of this issue and is working on a fix. You can test the API by using an external API testing tool, such as the one you mentioned: Postman. There is no exact date for a solution yet, but I will update you with any progress later. You can check the following official documentation for details on this known issue.

Known issue - Try it button missing on REST API pages

Regarding the authorization issue you mentioned, you can refer to the below methods in this thread to resolve it.

1. Call the GenerateToken API

Power BI REST API using postman - generate embed token.

Note:

1) You will likely need to create the App registration FOR YOUR ORGANIZATION (i.e. User Owns Data option)

2) Make sure to record the Application Secret which is displayed on your screen after the app is registered

3) When granting permissions in the Azure Portal, be sure to check "Grant Permissions for [Your Organization Name]"

2. Extract token using Powershell

Please follow below video to extract token using Powershell.
https://www.youtube.com/watch?v=f7HLyiAk-lQ (Credits - Adam(#GuyInACube))

Note - if you're using powershell for the first time, U will need to install Powerbi Module by running below command in Powershell as adminstrator.

Install-Module -Name MicrosoftPowerBIMgmt

Best Regards

Re: Authenticate REST API

Tweeg — Wed, 11 May 2022 07:17:44 GMT

But then I am authenticating with an application right? And like I mentioned:

When authenticating with my service principle, a lot of API calls give me the following response: "Message": "API is not accessible for application".

I need to be able to authenticate with my personal user account.

The option to retrieve a key using powershell works, but thats via powershell and i would like to do it in postman/ any given API tool without putting powershell in between.

Re: Authenticate REST API

Anonymous — Fri, 13 May 2022 09:17:59 GMT

Hi @Tweeg ,

Please check if it hit any following limitations of using service principal just as the situation in the below threads:

Error while executing Get dataset call "API is not accessible for application"

I was able to find the reason why. This was because I was trying to work on the data form My Org and this is a limitation in the Service Principal method:

Considerations and limitations

Service principal only works with new workspaces.

My Workspace isn't supported when using service principal.

In addition, please check if you have the similar status with the following threads. If yes, you can refer their solution to fix your problem...

PowerBI API error updating Dataset using Service Principal

The URL in the Microsoft API documentation is wrong for service principals.

You need to also include the workspace ID in the URL, see below
https://api.powerbi.com/v1.0/myorg/groups/{WorkspaceID}/datasets/{DatasetId}refreshes

Power Bi REST API - 401 Authorization error when using Service Principals

Best Regards

Re: Authenticate REST API

Anonymous — Wed, 24 Aug 2022 06:40:05 GMT

Hi @Tweeg ,

The related team have fixed the Power BI Known issue : "Try it" button is missing on every pages in PBI REST API , please check if it is OK in your side. Thank you.

Best Regards