Stack Overflow
Stack Overflow

Questions tagged [powerbi-rest-api]

Using Power BI REST API, you can create apps that integrate with Power BI reports, dashboards, and tiles.

49 questions
5
votes
2 answers

Power BI Rest Api Dataset in Power Bi Desktop

I successfully managed to connect a java application to Power BI REST API and managed to create a dataset and added some data. I can view this data from Power BI web interface, make reports, graph etc. Is it possible to connect Power BI Desktop to…
Sebb77
  • 2,431
  • 2
  • 17
  • 18
3
votes
0 answers

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 the workspace: import json, requests, pandas as…
Joy
  • 1,171
  • 9
  • 15
3
votes
2 answers

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-data/asynchronous-refresh) states: The response also…
Luukv93
  • 339
  • 1
  • 6
  • 19
2
votes
1 answer

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 the dataset, I mean the row-level data contained…
Mark Rullo
  • 119
  • 10
2
votes
1 answer

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 UpdateDatasourcesInGroup public static void…
Neehar Gadam
  • 43
  • 4
1
vote
1 answer

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: But when I using below json body (Get it By…
Joy
  • 1,171
  • 9
  • 15
1
vote
1 answer

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 complete this, but I am not familiar with power bi's…
Joy
  • 1,171
  • 9
  • 15
1
vote
1 answer

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="********" $password= ConvertTo-SecureString $secret -AsPlainText -Force $credential=…
Jishnu G S
  • 11
  • 2
1
vote
0 answers

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 datasource, but I´m stuck when I try to create a Databricks…
Rafael Espirito Santo
  • 21
  • 2
1
vote
1 answer

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…
A.D
  • 47
  • 1
  • 1
  • 11
1
vote
1 answer

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 have a "template" report and when a new scenario is…
Martin
  • 303
  • 5
  • 14
1
vote
1 answer

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//refreshes' -Method Get When I run it, the returned JSON data is like this, { "@odata.context":"/myorg/$metadata#refreshes","value":[ { …
MetallicPriest
  • 29,191
  • 52
  • 200
  • 356
1
vote
1 answer

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 website and others and trying some code snippets I've…
Bill
  • 11
  • 1
1
vote
1 answer

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…
Sanjibsrkr
  • 15
  • 4
1
vote
1 answer

Invoking PowerBi rest api and generate token

I want to invoke PowerBI rest api calls to upload pbix files from local/specific repository. How should I generate bearer token for authorization from Postman? Will this rest api call work to generateToken? What needs to passed as authorization…
Amruta
  • 701
  • 4
  • 15
  • 38
1
2 3 4