Stack Overflow
Stack Overflow

Questions tagged [powerbi-api]

66 questions
1
vote
1 answer

Is it possible create or link a report to an Azure Data Storage programatically

I would like to use PowerBI Rest API to connect a report to an azure table storage from my NodeJS backend. Let's take a basic example: I have already created a report and connected it to Azure Table manually using Power BI Desktop. Now I would like…
infodev
  • 4,673
  • 17
  • 65
  • 138
1
vote
1 answer

Cannot generate embed token using access token in power bi

I'm trying to be understand authorization mechanism in power bi API I would embed a report in my web app. I have done the steps as mentioned in docs Actually I would get report embedded url then use power bi JS API to embed the report. Getting…
infodev
  • 4,673
  • 17
  • 65
  • 138
0
votes
0 answers

Basic Http authentication using token

I am trying to extract data from an api using power query for further analysis but unfortunately its throwing an error saying we couldnt authenticate with credentials provided, please try again. The api uses basic authentication and there are…
User8985
  • 1
  • 3
0
votes
0 answers

how to obtain token with Microsoft Graph & Power BI Service scope together

I want to obtain a token for graph api and power bi service api, tried to make scope parameter as below https://graph.microsoft.com/.default https://analysis.windows.net/powerbi/api/.default offline_access but it give error The scope…
Liyang
  • 45
  • 6
0
votes
0 answers

Get power bi dataset tables (Automate)

I'm trying to find a way to get power bi dataset tables (Automated way). I tried using Powershell rest API: $tablesUrl = "https://api.powerbi.com/v1.0/myorg/datasets/$datasetId/tables" # Invoke the REST API to get dataset tables $tablesResponse =…
A H.
  • 41
  • 5
0
votes
0 answers

Embedding part of API code in PowerBI Dashboard

I'm setting up some Dashboards in PowerBI based on data imported via an API. All the dashboards contain the same visuals, just the back-end data is specific to each client. The API call is the same, apart from the end part of the key, which is…
DrewSmith
  • 47
  • 1
  • 6
0
votes
0 answers

Getting dataset refreshes as admin through Power BI REST API with PowerShell

I have a Power BI workspace with GUID [$group] and in it there is a dataset with GUID [$dataset]. From the Azure Cloud Shell I can run the following code: Connect-PowerBIServiceAccount # I log in with my personal credentials $Url =…
57Jimmy
  • 101
  • 1
0
votes
0 answers

How to refresh Power BI API access token in Power Query automatically?

I am seeking a way to automatically obtain and refresh a Power BI API access token within Power Query. I intend to use this token for further reporting, as documented by Microsoft here: https://learn.microsoft.com/en-us/rest/api/power-bi/ I have…
Piotr
  • 1
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 =…
Gareth Fairclough
  • 1
  • 1
0
votes
0 answers

Calling power bi rest api using adf integration to generate pdf and put on blob storage

Power-bi Integration with ADF to generate pdf and upload it on blob storage I am trying to call power bi rest API using below method. For First WebActivity URL: https://api.powerbi.com/v1.0/myorg/groups/{groupid}/reports/{reportid}/ExportTo Method:…
M.na
  • 1
0
votes
0 answers

Problem publishing Report that uses a separate On prem dataset via PowerShell

My goal is to set up an Azure DevOps pipeline that can publish a report to the Development workspace. The below code uses a service principle account to authenticate and then successfully publishes my test .pbix file (LocalReportModel.pbix") this…
Gareth Fairclough
  • 1
  • 1
0
votes
1 answer

How to Retrieve Power BI API Access Token without Manual Login?

Unable to retrieve Access Token from Power BI API, making use of Azure Active Directory Details. I'm currently making use of Postman to first test if I can Successfully request an Access Token form Power BI. Postman GET Request: I'm getting this…
Hanno Seegers
  • 1
0
votes
1 answer

Failed to upload the PBIX files to PowerBI workspace

I am trying to upload a PBIX file to the Power BI workspace by calling an API using the powershell code below. The token returns a bearer key. I am able to retrieve the workspace ID as well, but when I try to upload the file, I am getting the below…
DevOps
  • 19
  • 5
0
votes
0 answers

Unable to make Power BI api call from Custom Power BI visual

When attempting to make a call, I encountered errors related to Cross-Site Scripting Protection (CSP) and Cross-Origin Resource Sharing (CORS). Please someone help me making it happen. Thank you.
Nick
  • 1
0
votes
1 answer

Slicer Filtering in power bi api not working as expected C#

I need to export a pbi report into pdf with slicer filters.  I have created an ExportReportRequest object and passed to await Client.Reports.ExportToFileInGroupAsync(GroupId,ReportId, exportRequest); var exportRequest = new ExportReportRequest    …
Muhammed Irshad
  • 33
  • 5
1
2
3 4 5