Stack Overflow
Stack Overflow

Questions tagged [powerbi-gateway]

13 questions
1
vote
0 answers

PowerBi Gateway Issues

I am trying to set up a PowerBi Gateway which was there already but was pointed to a different VDI. Now since that VDI is corrupt, I deleted the older gateway connection, and installed the gateway in the new VDI machine. I am able to see a gateway…
Sowndarya Raja
  • 11
  • 1
0
votes
0 answers

Using Power BI Rest API to get datasource details

I am trying to get datasource details from powerbi through this REST API endpoint GET https://api.powerbi.com/v1.0/myorg/gateways/{gatewayId}/datasources/{datasourceId} I had a few doubts - where and how to get the datasourceId? And also when I run…
Musthafa
  • 1
0
votes
0 answers

Power Bi : Failed to update data source credentials: 'No connection could be made because the target machine actively refused it'

I wanted to schedule refresh of my power bi reports. My database server is running on port 5432. I have installed Power Bi gateway personal mode. So while doing this in option called Data Source Credentials while editing credentials even after…
Dattatray Dhonde
  • 1
  • 1
0
votes
0 answers

Mysql syntax error when refreshing a dataset

This error occurs on the Power BI web app. It says I can't connect to an undefined dataset and it says I have a SQL syntax error. I get this error everytime I try to refresh the dataset The thing is, there is not syntax error on the query. The…
evertonschneider
  • 1
  • 1
0
votes
0 answers

Error while adding DataSource in powerbi gateway using power shell

I am using powershell for .pbix to deployment in workspaces. As part of that i need to create SQL datasource under gateway for further use. I am using powerbI rest API with service principle :…
Riyaj Shaikh
  • 108
  • 7
0
votes
0 answers

Add Jobs in Background using Powershell (For Upgrading PowerBI Gateways)

I need help from PowerShell Expert to achieve the requirement which I have. We are using PowerShell Automation Script to upgrade Power BI Gateways and we have around 160 VMs. And the Process is performed sequentially meaning next machine cannot be…
Mohammed_A
  • 1
0
votes
1 answer

Power BI Gateway on Remote Desktop Fails Daily

Trying to install a standard gateway on a Remote Desktop. The gateway works for about 24 hours and then fails. Once I login to the "On Premise Gateway" app, and restart the gateway it works again for another 24 hours. The error message the…
PowerBI4Life
  • 1
  • 2
0
votes
1 answer

Power BI Gateway Data Sources Usage and Statistics

I am trying to clean up my Power BI Data Gateway Data Sources. How can I find data on which published reports use which data sources, and statistics on refresh times and failures?
Sunshine State Programmer
  • 9
  • 2
0
votes
1 answer

Trying to understand problem automatically refreshing Power BI data

I'm an experienced developer who knows very little about Power BI. So we've hired some consultants to implement our Power BI screens. And I provided them with a read-only login to my SQL Server database. It works okay, but when we complained that…
Jonathan Wood
  • 65,341
  • 71
  • 269
  • 466
0
votes
1 answer

LinkedIn PBI Custom Data Connector - Error when scheduling a report refresh

Such as to report on a company's LinkedIn page from Power Bi, I created a LinkedIn app, with the required scope (using the Marketing Developer Platform product), and developed my own custom data connector to access the API. I don't have any issue…
BereH
  • 1
  • 3
0
votes
0 answers

Power BI Gateway - MySQL source doesn't support encrypted connections

Currently, I have a Power BI report which is connected to a MySQL database on an onprem server. On the BI Desktop, I am able to connect to it, but after publishing and trying to connect with onprem gateway I am unable to access it! I get successful…
Gursimran Bedi
  • 1
  • 1
0
votes
3 answers

Power BI error when connecting to sharepoint

One of my dataset is failing to refresh with the error : SharePoint: Request failed: https://bconline.sharepoint.com/sites/xxx/Shared Documents/xxxx_xlsx/_api/contextinfo This usually is an intermittent issue. I am trying to find the root cause for…
ag1
  • 11
  • 1
  • 3
0
votes
2 answers

How to add PowerBI Gateway to existing cluster using PowerShell Cmdlets?

I managed to install PowerBI Gateway programatically Install-Module -Name DataGateway -Force -Scope AllUsers Login-DataGatewayServiceAccount Install-DataGateway -AcceptConditions Now I am looking for a way to add this gateway to existing cluster.…
Mike Chaliy
  • 25,801
  • 18
  • 67
  • 105