Forum Discussion
Authenticate REST API
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.
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
4 Replies
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
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.
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}refreshesPower Bi REST API - 401 Authorization error when using Service Principals
Best Regards
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
