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
0
votes
0 answers
Power BI Rest API Crashing on ExportToFileInGroupAsync
I'm attempting to use the microsoft power BI API to export a report a PDF file version. I'm able to successfully authenticate power BI with azure and can get a bearer token before making this call.
The ExportToFileInGroupAsync(reportId, groupId,…
user1299379
- 381
- 2
- 4
- 13
0
votes
0 answers
Facing token generation issue in case of data source using direct query
When I'm issuing a POST request to generate a token for a datasource using a direct query connection:
POST https://api.powerbi.com/v1.0/myorg/GenerateToken
I'm receiving the following error:
{ "error": { "code": "InvalidRequest", "message":…
zed101
- 193
- 1
- 2
- 10
0
votes
0 answers
PowerBI Create Dataset from a Postgresql datasource using REST API
I created a datasource behind gateway for using rest API. Datasource got created. However, now I want to add a table(create a dataset) from the created datasource to use it in a report. However, I am getting the below error from API.
{
"error":…
Aman Khandelwal
- 148
- 1
- 13
0
votes
1 answer
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 configured it as SPA.
b. i have allowed…
navinrangar
- 904
- 10
- 20
0
votes
0 answers
POWER BI REST API - executedatasetqueries to return measure value
I am trying to evaluate\return a measure value using below Power BI Rest API
executedatasetqueries
What would be the correct way to put the measure name?
Below is what I tried in Body Section:
{
"queries": [
{
"query": "EVALUATE…
Joseph
- 530
- 3
- 15
- 37
0
votes
2 answers
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 issue is azure token gets expired in 1hour. Can I…
Prabhakaran T
- 3
- 2
0
votes
1 answer
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": [
{
"rows": [
…
jitender singh
- 57
- 10
0
votes
0 answers
AzureCLI Credential fails on Tabular Object Model authentication
I am writing code to connect to power bi via TOM (Tabular Object Model) as opposed to the Rest API. Apparently the same authentication token can be used for both the REST API as well as TOM connectivity. As per here…
Gotts
- 2,274
- 3
- 23
- 32
0
votes
1 answer
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.
Details:
Value=
Position=4
supc
- 13
- 1
- 5
0
votes
1 answer
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 ${app_id} -p ${password} --tenant ${tenant_id}
$token=…
Joy
- 1,171
- 9
- 15
0
votes
0 answers
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 workspace.
On workspace A I have :
Dataset + report
A Report…
Tal_87_il
- 29
- 1
- 7
0
votes
1 answer
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 done via metadata translations ( DAx Editor ->…
Chris
- 29
- 3
0
votes
0 answers
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 CSV.
I use the invoke command to get user access…
Davyk
- 1
0
votes
1 answer
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 issue, when I'm making more than 5 post http…
katilinas
- 11
- 2
0
votes
1 answer
How can I export customized Power BI reports as PDF or PowerPoint on demand after embedded into an application?
Scenario: We consumed Power BI reports into our application. The user is changing report style (Example: Bar to Donut) on-demand and the user wants the selected style to export into PDF or PowerPoint (.ppt).
Is it possible with the Power BI REST API…
nuthanmurari
- 49
- 1
- 11