Stack Overflow
Stack Overflow

Questions tagged [data-gateway]

The on-premises data gateway is connectivity software from Microsoft which enables access to on-premises data from within Azure-based platforms such as Power BI or PowerApps.

43 questions
0
votes
1 answer

azure Devops pipeline setup for on premises data Gateway

I am trying to setup oracle data gateway using Azure Devops pipeline, but i didn't found any document. Please help me on this. please guide me how to setup oracle data gateway using azure devops pipeline and please send me if you have any documents.
Mohammad Hafiz
  • 19
  • 6
0
votes
1 answer

Azure data gateway & logic apps - storing sql server login details

With azure data gateway and powerbi, credentials used by the gateway to connect to each source are configured within the powerbi service. When using the gateway with logic apps, i cannot find a similar way to set up credentials to data sources. e.g.…
wilson_smyth
  • 1,202
  • 1
  • 14
  • 39
0
votes
1 answer

Is there a way to create a cache or synchronize project online (office 365 tenant) with on-prem project online instance using local data gateway?

I'm using a project online setup with data in my online office 365 tenant. I have some projects in this tenant. And I have created reports for this in Power BI. My login for online uses email id: name@anotherdomain_name.com My on-prem uses:…
trueorfalse
  • 31
  • 8
0
votes
1 answer

How to route on-premise data gateway traffic through Site-to-Site VPN

I have a logic app which requires to access a file which sits on on-prem server. for File System Connector, I have installed on-premise data gateway. It basically works. But I want to route traffic via Site-to-Site VPN which we have setup between…
user2748366
  • 143
  • 1
  • 1
  • 8
0
votes
0 answers

Connecting to different on premise servers with the same logic app

I was wondering if there is a way to use a logic app to get a task done on multiple directories in different servers. What i'm after is a way to get a task done in a looping manor. For example using a list to loop through, with the server and…
H4p7ic
  • 1,669
  • 2
  • 32
  • 61
0
votes
1 answer

Accessing On-Prem SQL Server from Azure without using an On-Prem data gateway in between

Can we access an on-premise SQL Server without using an on-premise Data Gateway from Azure? is there any other work around? like with a compromise in security/protocol? I am doing a POC project and would like to access an on-premise SQL Server from…
se7vanj
  • 160
  • 2
  • 8
0
votes
2 answers

Reconfigure On Premise Data Gateway desktop app

I have by mistake configured my on premise data gateway to point to a wrong data center. Now I am unable to reconfigure the gateway desktop app. I tried uninstalling and reinstalling the data gateway. But as soon as I login to the desktop app it…
Tiklu Ganguly
  • 337
  • 2
  • 10
0
votes
0 answers

On-Premise data gateway to SQL Server, database name has period

I'm trying to connect to a SQL Server database with the On-Premise Data Gateway, but unfortunately I have a period in the name of the database (yes, I know it's a bad idea). The gateway will successfully connect to databases without a period in the…
Mark Rullo
  • 119
  • 10
0
votes
3 answers

Error connecting logic app to sap hana server using sap .net connector

I want to connect sap to azure logic app ... I have a sap server and via on-premise gateway and .NET connector 3.0 i am trying to create a SAP connection in Logic Apps using "SAP Application Server - Send to SAP" action but in vain !! The error…
Arpit Kumawat
  • 1
0
votes
2 answers

How many times does an on-premises Data Gateway used in multiple reports connect to the same data source?

So, I am pretty new at using Power BI, so I'm having some issues when building reports that use on-premises Data Gateway. My goal is to build different reports in Power BI (let´s say 4 reports, as an example), all of them getting information from…
Pedro Martins de Souza
  • 1,406
  • 1
  • 13
  • 35
0
votes
1 answer

Integrate ADO.NET provider on On-premise Data Gateway with PowerApps

I am trying to integrate a large number of data sources available through a custom ADO.NET provider on a Windows server into PowerApps. To make the data available, I am using v14 of the On-premise Data Gateway (non-personal mode). The gateway…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Client unable to access shared SQL Server (on-Premise) connection

I have a shared application in Powerapps using 2 different SQL connections hosted by 2 different On-Premise gateways. Multiple users are using the App without issue -- everyone has the same share permissions (shared with app, gateways and…
Nicholas Patton
  • 786
  • 3
  • 8
-1
votes
1 answer

Why does Excel require less information for querying a SQL Server than Power Apps?

In Excel 365 desktop, I can: Open a blank workbook Click on the 'Data' ribbon Click 'Get Data' Click 'From Database' Click 'From SQL Server Database' Fill in the 'Server' field Click OK and that's all that I need to query my SQL server.…
J. Mini
  • 1,868
  • 1
  • 9
  • 38
1 2
3