Using Power BI REST API, you can create apps that integrate with Power BI reports, dashboards, and tiles.
- Power BI REST API reference
- Power BI Developer samples
- .NET SDK (official)
- PowerBI PHP SDK (community-driven)
Questions tagged [powerbi-rest-api]
49 questions
1
vote
1 answer
Tiles, copy visual as image in powerbi using rest api
I am new in Powerbi. I have requirement to download tiles using powerbi api. tiles reside at below url.
https://app.powerbi.com/groups/me/apps/{appid}/reports/{reportid}/{ReportSection}
I have access to app, i can see the reports in Powerbi.
I have…
Sanjeev Gautam
- 353
- 3
- 15
0
votes
0 answers
Power BI Embedded - Filtering not working
I am trying to embed a Power BI report into my Laravel project using the Power BI REST API. The report is loading successfully. However, I am facing issues with applying filters to the report, specifically using a column named 'Partner Name' from…
ni9khil
- 1
- 5
0
votes
1 answer
ConfidentialClientApplicationBuilder bearer token unauthorized
I am trying to access Power BI web api from my web application. For msal, I can get the correct access token when I use PublicClientApplicationBuilder with my organizational email and password.
but I dont want that. It exposes my email and…
TanvirAhmedKhan
- 29
- 4
0
votes
0 answers
"Groups UpdateGroupAsAdmin" API throws 401 Unauthorized error
I'm using Admin - Groups UpdateGroupAsAdmin API to update description of the workspace.
Workspace access is configured: service principle, which I use to authenticate API, is set as Admin for my workspace (also as described in this thread Unable to…
kosist
- 2,868
- 2
- 17
- 30
0
votes
0 answers
Get Power BI workbook icon using REST API
I'm using REST API described here https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-group-as-admin to fetch/post data from/to Power BI app in my tenant.
It is possible to set custom image for the workspace manually, from web…
kosist
- 2,868
- 2
- 17
- 30
0
votes
0 answers
Not able to install Powershell module in Corporate environment
I am new to Powershell and I have to write one script to automate some process, so I used below command
Install-Module -Name MicrosoftPowerBIMgmt
PackageManagement\Install-Package : No match was found for the specified search criteria and module…
UTKARSH SHARMA
- 11
- 3
0
votes
0 answers
Power BI REST Admin - Datasets GetDatasourcesAsAdmin return DMTS_UserNotFoundInADGraphError
I got this DMTS_UserNotFoundInADGraphError error when using Power BI REST Admin - Datasets GetDatasourcesAsAdmin API to get datasources.
Here is the full error
{
"error":{
"code":"DMTS_UserNotFoundInADGraphError",
"pbi.error":{
…
Perat Damrongsiri
- 23
- 5
0
votes
1 answer
Power BI REST API - Unable to get visuals and fields within report page
I am looping across power bi reports>pages>visuals and then fields within them , the code to retrieve pages works fine, however there is an issue with visual url, in Visual response it says - No HTTP request was found that matches the url.
I get an…
Joseph
- 530
- 3
- 15
- 37
0
votes
0 answers
How to export a list of all users that have access to reports from a Power BI Workspace?
I am trying to audit Power BI reports and datasets to see who have access to which reports. Is there an API that allows to do so?
Ideally, my output file should have at least three columns: report, user, level of access
Is it possible to get this…
Mohsen Alam
- 11
- 1
0
votes
0 answers
Authentication Issue with Power BI REST API - executeQueries
I am trying to execute a DAX on a Power BI dataset published in Premium workspace using below Power BI Rest API.
https://api.powerbi.com/{api_version}/myorg/groups/{workspace_id}/datasets/{dataset_id}/executeQueries
And below is the full code
import…
Joseph
- 530
- 3
- 15
- 37
0
votes
1 answer
Power BI Rest API getting unauthorized error, even though my application have all the permissions (non-admin) - Getting access token but can't use it
I am pretty new using APIs but i wanted to capture a couple of information regarding my dataset.
I created an application in azure active directory and added bunch Power-Bi API permission (read.all). I am a non-admin, so our admin granted consent to…
arsh
- 11
0
votes
0 answers
Problem publishing a .pbix file to PBI Workspace using the rest api and PowerShell
I am trying to publish a Power BI Report via a PowerShell script.
Has anyone had much experience with this as I can't quite get it to work using this method.
$clientId = "****"
$clientSecret = "****"
$tenantId = "****"
$apiUrl =…
0
votes
0 answers
Using Power BI Rest API to get datasource details
I am trying to get datasource details from powerbi through this REST API endpoint
GET https://api.powerbi.com/v1.0/myorg/gateways/{gatewayId}/datasources/{datasourceId}
I had a few doubts - where and how to get the datasourceId?
And also when I run…
Musthafa
- 1
0
votes
1 answer
How to generate Access Token for Azure with grant type password? PowerBI REST API
I want to be able to get access tokens automatically without the need of user interaction (that is manually typing the credentials in an OAuth pop-out).
I'm using grant_type: password for this; however, I'm getting an invalid_grant error, saying the…
Daniel Rivas
- 15
- 4
0
votes
0 answers
Update measure description for Power BI dataset published in Premium Workspace in import Mode
I have a Power BI dataset, published in premium workspace in import mode. I am trying to programmatically update the description for all the measures in the dataset, using below code
import json
import openai
import requests
import…
Joseph
- 530
- 3
- 15
- 37