Stack Overflow
Stack Overflow

Questions tagged [powerbi-api]

66 questions
4
votes
2 answers

PowerBI API error updating Dataset using Service Principal

Requirement: Update PowerBI dataset schedule using Powershell script via a Service Principal. PowerBI API used. Refer: MicrosoftDocs Error Message: "Message":"API is not accessible for application" What I did: Provided PowerBI application API…
KaranSingh
  • 460
  • 4
  • 11
3
votes
0 answers

Azure Runbook still return error when using Get-PowerBIActivityEvent

I'm struggling to make my azure account automation runbook work. Logging using Login-PowerBIServiceAccount is working correctly, but with these commands, Get-PowerBIActivityEvent, Get-PowerBIWorkspace I get the error: Attempted to access an element…
riwik
  • 41
  • 2
2
votes
0 answers

How to trigger a PowerBI Datamart refresh from Azure Synapse Pipelines?

Currently we are able to trigger an automated refresh of PowerBI datasets with an activity in Synapse Pipelines leveraging PowerBI API. Is it possible by any chance to do the same with a PowerBI Datamart? Couldn't find any reference for this…
datatalian
  • 83
  • 1
  • 5
2
votes
2 answers

Power BI Activities Log REST API Get Access Token

I have been going crazy trying to pull activity logs from the Power BI Rest API. I can do it using this "try it" method from Microsoft https://learn.microsoft.com/en-us/rest/api/power-bi/admin/getactivityevents I have to login to use this tool and…
Brpat
  • 63
  • 4
1
vote
0 answers

PowerBI - Publish report with Api

I have two tenants, one for Development and one for Production We develop the reports from PowerBI Desktop and publish the pbix by publishing directly from PowerBI Desktop To publish the content on both tenants I have to switch accounts every time…
Davide Bono
  • 63
  • 5
1
vote
1 answer

How to update credentials of Dataset (based on data flow) using service principal

I am facing an issue while patching the credentials of a data set. Our application is using the service principal to upload PowerBI reports to the respective PowerBI workspace. Most of the report is using Web Api sources, so we are patching the data…
arun
  • 21
  • 3
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

PowerBI API ExportToFileInGroup, PNG format doesn't work, PDF, PPTX works correctly

I have a problem with the ExportToFileInGroup API method. According to documentation, PowerBI reports can be exported to a few different formats, for me the most useful are PPTX, PDF, and…
Krzysztof Krysztofczyk
  • 627
  • 5
  • 17
1
vote
2 answers

Is there any Power Bi api available for providing access to Dataset?

I have found api for adding user to workspace(group) as well as Add Datasource user. I would like to know, if there is any api available for adding user to dataset? From the Power Bi Web portal, this is accessed by: Workspace -> Datasets + Dataflows…
Sreejith Sreekumar
  • 13
  • 3
1
vote
1 answer

How to download the report as an excel in the PowerBI

How to download the report as an excel in the PowerBI. Currently, I have embedded the report in the SharePoint page using the PowerBi web part, would need to download the report using a download button. I have used PowerBI API - POST…
Nanda
  • 49
  • 1
  • 6
1
vote
1 answer

Call Power BI Reporting server Api using Token Based Authentication

Hope you are doing great! I am creating a windows service(.net core) project that will fetch all the reports from Power BI Reporting Server and send emails to the users as per schedules. There will be a link in email to access the report or the…
Rahul
  • 156
  • 2
  • 21
1
vote
1 answer

Automatically Exporting PowerBi Visualisation Data?

I need to automatically extract raw data of a PowerBI visualisation across multiple published reports. Why not just pull the underlying dataset? Because the visualisations are using anomaly detection features of PowerBI, which include anomaly flags…
Cazzym Hawkins
  • 303
  • 1
  • 5
1
vote
0 answers

Update PowerBI datasource parameters programatically using PBI API

I would like to update my datasource credentials to AzureTable Storage. To know how is the format of the credentials I maked a Get datasources infos on an existing already linked dataset ( via power bi desktop ) { "@odata.context":…
infodev
  • 4,673
  • 17
  • 65
  • 138
1
vote
1 answer

R/PowerBI API question: How to assign NA for the missing columns in the resultant data frame when the structure of source data frame is not consistent

I am working on parsing data from PowerBI REST API for activity data. The way this API functions is - the same end point may return data with 10 fields today and tomorrow it may return with 15 fields. My goal is to run a scheduled process that would…
Jade
  • 56
  • 5
1
vote
1 answer

Could not pass custom parameters while loading paginated reports in powerbi javascript api

Goal: Load a paginated report into webpage which has few parameters with the help of powerbi api javascript. Paginated…
Sudipta Kundu
  • 11
  • 3
1
2 3 4 5