58 questions
0
votes
1
answer
385
views
Get Power BI Report Data from REST API with Service Principal
I have a service principal configured to access Power BI. I can successfully use the REST API to get metadata about dashboards, reports, and datasets. What I can't seem to be able to do is get the ...
0
votes
1
answer
91
views
Power BI import PBIX file with quarkus-rest-client
I am currently facing an issue to call the "POST import" endpoint of Power BI Rest API.
I have to import a pbix file (that is far less than 1GB so that's good for that).
My application uses ...
1
vote
0
answers
54
views
Power BI REST API while passing filter parameter report is not getting filtered
I am try to filter report before export but its not getting filter and even no error.
Rest API:
https://api.powerbi.com/v1.0/myorg/reports/reportId/ExportTo
Code:
using var client = new PowerBIClient(...
0
votes
1
answer
45
views
Using roles in a more efficient way (PowerBI)
I have a table called Stock, used as a dataset in PowerBI, exposing these columns:
CustomerId
ProductName
Quantity
The report (visual) is just a bar chart that shows how much of a product has each ...
0
votes
0
answers
193
views
How to get Workspaceid from known reportid/datasetid in PowerBI using Rest Apis
First off, I have a reportid, from there I have hit the api(GetReport) to get the datasetid.But now I wanted the corresponding workspaceid,How can I get it.
2
votes
1
answer
603
views
Is it possible to bind a Cloud Connection datasource in Power BI using the API with a Service Principal?
I have been using the Power BI API to bind a gateway and a couple of datasources to a datamodel. However, my datamodel is also connected to a cloud datasource, which obviously has no gateway related.
...
-1
votes
1
answer
82
views
Need to establish relation between tables in create semantic API for PowerBi
Currently i am able to create semantic layer through fabric API(https://learn.microsoft.com/en-us/rest/api/fabric/semanticmodel/items/create-semantic-model?tabs=HTTP&tryIt=true&source=docs#...
0
votes
0
answers
108
views
Code to execute DMV queries on Power BI Datasets without using Client ID and Secret
Using below code to query DMV, primary on system tables $SYSTEM.TMSCHEMA_TABLES, I dont have a client id and a secret rather I have a valid Power bi access token that has read write access to the ...
0
votes
1
answer
698
views
PowerBI REST API get reports
Making a GET call to https://api.powerbi.com/v1.0/myorg/groups returns workspace.
{
"@odata.context": "https://wabi-canada-central-b-primary-redirect.analysis.windows.net/v1.0/myorg/...
0
votes
1
answer
428
views
Power BI REST API - Get reports from all workspaces built on a specific datasetid
I am using below API to get list of all reports present in a particular group/workspaceid
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports
Now, I have a dataset in my workspace and ...
1
vote
1
answer
118
views
How to use the PowerBI API to update an Azure Blob Storage datasource?
I've got a bunch of storage accounts, all holding similar data but from different environments, and I'm trying to generate a report per storage account in an automated fashion. I've got a PBIX file ...
1
vote
1
answer
632
views
Creation of streaming dataset is deprecated. We recommend exploring Real-Time Intelligence in Microsoft Fabric
Suddenly I can not create new dataset schema for power bi report in Azure. While trying to create new dataset schema via rest API it is showing me error. The error is :
"{\"error\":{\&...
0
votes
1
answer
789
views
Issue with Power BI Embedded API and 401 Unauthorized Error
I'm working on integrating Power BI Embedded using the REST API to retrieve the list of dashboards. I'm using client credentials flow with the correct client ID and client secret to obtain an access ...
1
vote
1
answer
287
views
What is the correct JSON body to disable PowerBi Schedule Refresh via API
This is the example Request body provided by Microsoft to disable a PowerBi schedule refresh via the Rest API
{
"value": {
"enabled": false
}
}
When I call the API, using ...
0
votes
1
answer
496
views
JSON Body query on Invoke-RestMethod Powershell method for Power BI Refresh
i'm currently developing a Powershell script to refresh a single table partition of my Power BI dataset using a POST API call through the Invoke-RestMethod.
# Connect the Service Principal
$password = ...
0
votes
0
answers
101
views
Tenant not found error while getting token from microsoftonline url
[] I am trying to get token through https://login.microsoftonline.com by passing clientid and client secret, the same request generate token through Postman successfully, but from C# HttpClient, It is ...
1
vote
0
answers
285
views
Pass parameter to DAX query with Power BI REST API and Python
The following Python script is written to access the data in the Power BI data warehouse externally.
import json
import requests
from cred import username, password, client_id, client_secret, ...
0
votes
1
answer
1k
views
Power BI REST API returning 404 for dataset datasources, despite dataset and datasources existing
I'm encountering an issue with the Power BI REST API while attempting to access datasources for a specific dataset using the endpoint https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/...
0
votes
1
answer
6k
views
Power BI REST API request error 403 when querying the dataset
I want to query the Power BI dataset using Power BI REST API, app to app authentication (Service Principal).
I am getting Error 403 (access forbidden) when sending request to Power BI dataset.
I have:
...
1
vote
1
answer
136
views
convert REST API - json output into table Power BI
After conversion of json output into table in Power BI.
However, I'm unable to transform above format into below format in Power BI.
Any suggestion how I can solve this problem in Power BI.
Thanks ...
2
votes
1
answer
401
views
Unable to create file in workspace Audience validation failed 401
Creating file in workspace with REST API:
PUT https://onelake.dfs.fabric.microsoft.com/{workspace}/{item}.{itemtype}/Files/sample?resource=file
Status code:401 Unauthorized
Error: Authentication ...
0
votes
1
answer
997
views
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, ...
0
votes
1
answer
804
views
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 ...
1
vote
1
answer
1k
views
The correct json body for updating Refresh Schedule with REST API
When I using the REST API to update the Refresh Schedule:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-refresh-schedule
I need the specify settings for the schedule like below:
...
1
vote
0
answers
169
views
REST API deploys repot or Dashboard separately with powershell
As we know, we could use the deployment pipeline only deploy the report or Dashboard from Dev environment to the next environment, like SIT.
Now I want to use the powershell invoke the REST API to ...
1
vote
1
answer
629
views
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":{
"...
0
votes
1
answer
1k
views
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 ...
0
votes
0
answers
2k
views
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, ...
0
votes
1
answer
6k
views
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). ...
0
votes
1
answer
2k
views
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; ...
1
vote
1
answer
484
views
How to Run PowerBI REST API in Azure Cloud shell
I'm trying to get the powerbi apps details using the Azure Cloudshell,
Here is the Powershell script i'm using,
$secret="********"
$tenantId="********"
$appId="********"
...
1
vote
0
answers
285
views
Error to create a Databricks datasource using Power BI Rest API
I successfuly used the "Gateways - Create Datasource" (https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/create-datasource) method from Power BI Rest API to create a SQL ...
1
vote
1
answer
5k
views
Access Token Scope Issue in Azure AD and Power
I'm working with Power Bi REST APIs, for which I need an azure ad token.
I have set up an app in Azure AD, and have configured it as.
a. I intend to use that access token in my react app so I have ...
0
votes
2
answers
3k
views
Can we refresh the access token in Power bi which is sent by Azure using React app.?
I'm using powerbi-client-react npm package for my project. When I sign in in the report the azure sends an access token passing token and embed URL, I'm accessing the power bi report via React. The ...
4
votes
2
answers
4k
views
Query a dataset with Power Bi REST APIs using a Service Principal
Our goal is to query a dataset that is published to PowerBI via the REST APIs ( https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries ). I'm not talking about the metadata of ...
0
votes
1
answer
791
views
how to store web activity result in a variable?
i have a web activity through which i am executing a rest API(execute queries)
this is a sample output of that:
{
"results": [
{
"tables"...
2
votes
1
answer
2k
views
Download Parametrized Report via Power BI Rest API
I have created a report with Power BI Report Builder and published it on Power BI Service. I have found 3 steps to download report via API
POST Request to start the process
https://api.powerbi.com/v1....
0
votes
1
answer
744
views
Azure DevOps Sprint Capacity in PowerBi using REST API
I am trying to read the Sprint Capacity from Azure DevOps to PowerBi using REST API.
I get this error, any solution to fix this?
DataFormat.Error: We found extra characters at the end of JSON input.
...
0
votes
1
answer
650
views
Get the 403 when using auth token authenticate for the PowerBI REST API
I want to use token authenticate for the Power BI REST APIs. Now I have a service principal, then I using the az command line to login in and generate the token:
az login --service-principal -u ${...
1
vote
1
answer
2k
views
Dynamically create a report
we are trying to implement the following:
We will have PowerBI reports for different scenarios. Each scenario has different data but it will use the same visual for the user.
Therefore, we need to ...
1
vote
1
answer
729
views
How do I get a field from a JSON returned by Invoke-PowerBIRestMethod
So, I have a code like the following.
$x = Invoke-PowerBIRestMethod -Url 'datasets/<dataset_id>/refreshes' -Method Get
When I run it, the returned JSON data is like this,
{
"@odata....
3
votes
0
answers
2k
views
Power BI REST API with python to publish the pbix files
I am new come to the python, but I need to invoke Power BI REST API with python to publish my pbix file in my repo to the workspace.
Based on this document, I could successfully authenticated and get ...
2
votes
1
answer
2k
views
Using MSAL and Python to Connect to Power BI REST API
I have my Power BI application registered in Azure Active Directory with select API permissions (such as User.Read). I've done my best to follow the MSAL documentation, along with searching this ...
0
votes
0
answers
547
views
Clone Power BI reports between tenants using Power BI REST API
I have 2 workspaces:
Workspace A hosted on tenant A: Vendor workspace which contains the product PBIX. "Golden workspace".
Workspace B: Client workspace, hosted on tenants B, client ...
0
votes
1
answer
195
views
PowerBI - Visual API - changing Visual properties | usage: translations
Context : we're having our powerbi dashboards embedded either as a whole report or only standalone visuals.
We want to translate the content of our reports in several languages. some of it can be ...
0
votes
0
answers
774
views
Parsing PowerBIRestMethod response to CSV
I've been working on a way to retrieve our PowerBI data, and managed to get exactly all the data I'd need to process, however I can't seem to figure out on how to actually parse the data to a proper ...
1
vote
1
answer
1k
views
Scanner API Call using PowerShell for multiple PowerBI workspaces
I'm trying to call a PowerBI GETinfo Scanner API using PowerShell. One of the requirements is to pass multiple workspaces to get the info. Here is the MS doc link :\
https://learn.microsoft.com/en-us/...
0
votes
1
answer
731
views
Power BI REST API - Error: connect: exceeded the limit of 5 sockets
Hello dear PBI REST API experts, I would appreciate any support on the following issue.
Trying to send data from MongoDB Atlas to Power BI Push Dataset through Rest API.
However I met the following ...
3
votes
2
answers
2k
views
Async refresh Power BI REST API: Response doesn't include location field that should contain refreshId
I try to refresh a Power BI Premium dataset programmatically by sending post request to PBI API endpoint: datasets//refreshes.
The documentation (https://learn.microsoft.com/en-us/power-bi/connect-...
3
votes
1
answer
780
views
PowerBIAPI - Operation is not supported for selector # - connection details contains parameters" - update ServerName in PowerBI Dataset of the Report
I have a Problem Updating the Server details in the dataset of the uploaded power bi Report. Please Help.
Here I used 2 approaches.
Approach 1
Used the below method in Microsoft.PowerBI.Api.V2
...