Stack Overflow
Stack Overflow

Questions tagged [onpremises-gateway]

The on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and several Microsoft cloud services, including Power BI, PowerApps, Microsoft Flow, Azure Analysis Services, and Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.

Types of gateways

There are two different types of gateways, each for a different scenario:

On-premises data gateway allows multiple users to connect to multiple on-premises data sources. You can use an on-premises data gateway with all supported services, with a single gateway installation. This gateway is well-suited to complex scenarios with multiple people accessing multiple data sources.

On-premises data gateway (personal mode) allows one user to connect to sources, and can’t be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you’re the only person who creates reports, and you don't need to share any data sources with others.

enter image description here

34 questions
1
vote
0 answers

How to use Active Directory based authentication in Power BI Service to query data as per user's entitlements from AWS Athena

I have a requirement that user need to connect Power BI cloud Service to Athena (via on-premises datagateway) and fetch the data according to the user persona setup in AWS. I understood from MS documentation that I need to have the above setup.…
Anandkumar
  • 1,338
  • 13
  • 15
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
1
vote
0 answers

Monitoring of Azure Hybrid Connections and OnPremise Data Gateway

I'm using the Hybrid Connection Manager and also the On Premise Data Gateway for several projects hosted in the Azure cloud. There are more and more use cases for those two components and I need to setup a clean monitoring to detect connection…
David GROSPELIER
  • 772
  • 1
  • 9
  • 35
1
vote
0 answers

Why do I need the on premises Data gateway?

I'm really confused, and a bit lost here. I have uploaded a data model (Using Visual Studio SSDT) to my Azure Analysis Service. I have configured my on-prem data gateway - (from Azure & on my laptop where my SQL Server is). Using power Bi desktop,…
houba
  • 496
  • 7
  • 20
1
vote
1 answer

Error occurred during the pre-login handshake, due to AntiVirus?

I need your expertise on one of my issues. I often get an intermittent issue from our Power BI on-premises Gateway to SQL connectivity Error from gateway log Error: A connection was successfully established with the server, but then an error…
Jayendran
  • 9,638
  • 8
  • 60
  • 103
0
votes
0 answers

Configuring Power BI dataset connection to Cloud PostgreSQL database

I have created some reports using Power BI(PBI) Desktop and it's PostgreSQL connector with DirectQuery for auto refreshing. The reports work well. The problem lies in publishing the reports to PowerBI.com and viewing the reports as I do on…
NathanGillespie
  • 1
  • 2
0
votes
0 answers

how to connect dataflow with webAPI using Dataflow PowerBI Service

Actually I'm beginner with powerBI service, I created DataFlow then filled in needed parameters to consume a WebAPI as you can see in this picture. configuration My problem is that I'm getting Data from Toggl so its not an on premises Data Source…
Sara NCIB
  • 3
  • 1
0
votes
0 answers

How to connect ODBC source to on-premises data gateway in power bi server?

Every time I am trying to create an on-premises data source using ODBC, I am getting this error. Can anyone explain to me what the problem is?? This error occurs every time The ODBC connection used for the same report in power bi desktop
Mr. Basu
  • 15
  • 4
0
votes
1 answer

how to create a window service using java?

is it possible to run a java program as window service is anyone done that successfully ,? I'm trying to create LDAP application using java, want to run a java application as a window service, java is good choice or not, if any of you guys done any…
durga murugan
  • 11
  • 4
0
votes
0 answers

SaaS to On-Premise: how to set up intern domains for private network overwhelmed with the question of the firewall

I recently started as a intern and I'm overwhelmed with my job. We have a product which is hosted externally. We only have a simple router. The Services should be running in Docker Containers with Reverse-proxy on a server. These services should be…
Robertt
  • 23
  • 4
0
votes
0 answers

couldnt acces to thingsboard on premise

I deployed thingsboard server in BECKHOFF C6017 ,this industrial PC is not equiped by wifi so i add and extender that i configurate it to acces point so i can connect to the beckhoff and have wireless acces to thingsboard , i configurate the…
Brell
  • 31
  • 6
0
votes
0 answers

On-premises data gateway and X-forwarded-For issue

I am using the Azure On-premises data gateway to automate Home Assistant using Logic Apps. However it appears that the data gateway is adding the port to the X-forwarded-for http header and Home Assistant does not like that and rejects the request.…
rukiman
  • 597
  • 10
  • 32
0
votes
1 answer

Power BI scheduled update to AWS RDS

Having a MariaDB database up in AWS RDS hosted through an EC2 instance, I still can't get Power BI to agree on scheduling updates. Is there anything I have missed? I have installed an on-premises data gateway on the EC2 instance I have installed an…
Springsomfan
  • 3
  • 2
0
votes
0 answers

Rename a Power BI On Prem Data Gateway

How can I rename an on prem data gateway? I have found questions and answers about this, but none of them appear to be correct. Let me explain: The gateway cluster can be renamed via the Power Platform Admin Center. The gateway cannot. Installing…
dougp
  • 2,810
  • 1
  • 8
  • 31
0
votes
1 answer

Power BI: On-premise gateway issues while using Excel file and database as data sources

this is probably something simple that I am overlooking, but here's what I have going on: I've built a dashboard that sources a few tables from my database. The report is also using an Excel file (which is stored on my local machine and our OnePoint…
Lisa M
  • 13
  • 3
1
2 3