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
1
vote
1 answer

Using a locally stored Excel file as data source, with updates from remote

I'm new to Powerapps, and am trying to solve this problem: The app will rely on a locally stored data file. Either based on an Excel file, or a Sharepoint list. That is, the app needs to be able to query this data while offline. But a second…
Christofer Ohlsson
  • 3,097
  • 4
  • 39
  • 56
0
votes
0 answers

Logic Apps Custom API Connector via Azure On-Premise Data Gateway

I have this Logic App that connects have Custom API Connector from Azure On-Premise Data Gateway. However, The API is not in the Server where the Azure On-Premise Data Gateway installed it is in the different Server. Is there someone who have the…
Jog
  • 3
  • 2
0
votes
1 answer

On-premises Data Gateway Compatibility with Azure ExpressRoute

I've been reviewing the documentation and haven't found the answer. Hoping someone will be able to assist here. We have an on-prem network that connects to an Azure tenant via ExpressRoute. We want to deploy an On-Premises Data Gateway to leverage…
user22354694
  • 1
0
votes
1 answer

Copy file from on-prem sharepoint document library to SharePoint online

I am trying to copy on-prem sharepoint files from a document library to sharepoint online document library using data gateway and power automate. I have tried using different methods but I either end up with corrupted files or the "file identifier"…
Yon
  • 3
  • 3
0
votes
1 answer

Azure DataGateway not showing as available for single user in Logic Apps

We have recently installed a Shared Data Gateway, however a single user is not able to see the Data Gateway within Logic Apps. When they search for Data Gateways (in the file system - create a file card) the dropdown is blank and lets them know…
Pittsburgh_Power
  • 1
  • 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
0 answers

Can I get an On Premises Data Gateway installation id to use in Bicep to Create a On Premises Resource in Azure

I am trying to create a bicep deployment set up in VS Code so that I can automate the creation of: Resource Group Logic App (Standard) Key Vault Storage Sql Connection On Premises Data Gateway I am having an issue with the creation of the On…
Luke
  • 21
  • 2
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

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

Why SQL (On-Prem using Data Gateway) Insert row (V2) action in Logic App does not populate tables?

I have an On-Prem SQL which I am accessing in my Logic App using On-Prem Data Gateway. I have created a table in my SQL database as per below: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Temp_Emp_CC]( [Timestamp]…
Victor McIntyre
  • 93
  • 1
  • 10
0
votes
0 answers

Use Powershell to access API behind Data-Gateway

I have been trying to make a REST request from within a Powershell script to a service behind a Data-Gateway (deployed on premise). I couldn't find any information about any Powershell modules that would allow us to contact Data-Gateway services via…
Jonathan P
  • 3
  • 1
0
votes
1 answer

How can I change the service account on the on-premise data gateway without getting the error "Service account or password is incorrect"?

Microsoft announced data gateway support for SSO with Azure AD in August. https://powerbi.microsoft.com/en-us/blog/announcing-data-gateway-support-for-single-sign-on-sso-with-azure-active-directory/ I need to change the service account on the…
Pål Skønberg Løvik
  • 405
  • 1
  • 6
  • 17
0
votes
1 answer

Query on usage of on-premises data gateway for connecting Azure Analysis Services

I have an application hosted in Azure infrastructure IaaS model. In this case, database: SQL Server 2017 is managed using Azure VM. For enhanced security isolation , the entire setup including the database server is leveraging VNets. Now we are…
santosh kumar patro
  • 7,231
  • 22
  • 71
  • 143
0
votes
1 answer

Azure DSC with PowerShell 7

I am trying to automate DataGateway in Azure and recently in powershell 7 were released library to manage it. But the problem that Azure DSC working with Windows Powershell 5 and even if VM have installed powershell 7 it's not working. Can someone…
Tiktack
  • 1
0
votes
0 answers

Setup On Premises Data Gateway using Powershell

I am trying to setup on-premises data gateway using powershell. i am able to install but i am unable to register with powershell. Can you please provide me step by step how to setup on-premises data gateway using powersehll
Mohammad Hafiz
  • 19
  • 6
1
2
3