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
0
votes
1 answer

Import and update power bi report with data gateway

I already installed and configured a data gateway, pls how do I import a power bi desktop report and make it refresh changes accordingly? Thanks.
greg616
  • 57
  • 4
0
votes
1 answer

How to send an HTTPS request through an On-Prem Data Gateway?

I setup an Azure Function locally as part of testing. I created a self-signed certificate and am able to send HTTPS GET requests to the Function via Postman. ' Example I just setup an On-Prem Data Gateway. The install went smoothly and I can see…
SeaDude
  • 3,725
  • 6
  • 31
  • 68
0
votes
3 answers

Azure VNET to VNET to site to site VPN connectivity

Scenario. We have a site 2 site VPN from ON PREM to Azure VNET (with a vnet gateway) in a specific rg. lets call the VNET with the VPN connection for: vnet-vpn Then we have a VNET in another Resourcegroup in Azure (Same subscription as vnet-vpn)…
tlogik
  • 1
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
1 answer

How to synchronize file systems to Azure Blob storage without using AZCopy?

I would like to sync or send files from the file system (via On-premises Data Gateway) to Azure Blobs. But, I need a solution different than using AZCopy. Is it possible to define a kind of Azure File Share which sync with Azure Blob Storage…
Ibrahim Schi
  • 309
  • 1
  • 9
0
votes
1 answer

difference between creating on-premise-gateway from Azure-portal and by downloading from the link as given in the description

I configured on-premise date gateway by downloading and installing from the Microsoft Azure-analysis documentation which I published below. However, I also found an option to create the same from Microsoft Azure-analysis portal. Here I am trying to…
Techchamp Pgm
  • 137
  • 11
0
votes
1 answer

How to copy the Azure blobs to on-premise Linux server?

I need to copy the blobs to Linux server. I was able to setup a logic app and copy the blobs to Windows server but not sure how can we achieve same with linux server. ?
Rishikesh Darwade
  • 11
  • 1
0
votes
1 answer

On-prem SQL Server to Azure

I have 2-3 source systems which are on-prem databases. I am planning to use Logic Apps to connect to these source systems. As per the Azure documentation we need to install a On-Prem Gateway on a local computer. I am skeptical of this methodology as…
user15364835
  • 1
  • 1
0
votes
0 answers

Connecting to SQL Server, server name problem

So I have a SQL Server set up on a remote server machine. And I am trying to connect to this remote SQL Server via the local pc. I can connect with no problem using ServerDnsName, or ServerDnsName,1433\SQLEXPRESS. But, what i would like is to…
dat
  • 9
  • 3
0
votes
1 answer

Importing / Exporting data with Dataverse (CDS)

I'm looking into using the dataverse (CDS). I have an on prem sql server and a server hosted on azure which is also on prem. I want to know if it is possible to Export data from dataverse into an on prem sql server Import data from an on prem sql…
MrPepperMan
  • 9
  • 3
0
votes
0 answers

How we can access and Fetch a data from SharePoint on-premises on mobile device Xamarin.Android?

How we can access and Fetch a data from SharePoint on-premises on mobile device Xamarin.Android ? http://domain/sites/MobileApp/_layouts/15/viewlsts.aspx, this is a URL. How Can i use this in xamarin.android Code. Thanks in advance.
Compass me
  • 11
  • 2
0
votes
1 answer

SSAS installation on Linux machine (CentOS 7)

I have a Virtual Machine with Linux (CentOS 7) with SQL server installed in it. Can I install SSAS in the machine and connect it through my local machine through SSMS? If so, how can I do so? Please help. Thanks in advance.
rohit10
  • 11
  • 2
0
votes
1 answer

how exactly does self hosted integration runtime authenticate itself to the azure data factory in the backend?

There are multiple articles online, which tell you about the process to setup an self hosted integration runtime, and I understand we need to copy the authentication key provided by ADF and use it when registering the integration runtime on self…
RUPAM MITTAL
  • 19
  • 4
0
votes
1 answer

Azure on prem data gateway for logic app sign in account

I have a customer server, who does not want us to access their server but to connect the logic app to the server I need to install the on prem data gateway and configure it. I have created a user in active directory for the respective subscription…
Amit
  • 167
  • 1
  • 2
  • 14
0
votes
0 answers

Powerbi Gateway - load-balancing

We are using today a gateway powerbi to collect data from our core-it infra to the powerbi service. Till today it's working fine but we only have one server and we are looking for a way to add an extra gateway in order to have a setup allowing to do…
Miguel Martin Perez
  • 119
  • 1
  • 10
1
2
3