Skip to main content
45 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
53 views

We are in the process of replacing an On-Premises Data Gateway running on a VM with a Virtual Network Data Gateway running in Azure; the VNet Data Gateway has full connectivity and name resolution to ...
Massimo's user avatar
  • 1,550
1 vote
1 answer
2k views

I am trying to create a Gateway Datasource for a PowerBI Semantic Model in a C# application: using (PowerBIClient pbiClient = new PowerBIClient(new Uri("https://api.powerbi.com"), ...
Ben Schmalz's user avatar
  • 61
0 votes
1 answer
112 views

I have a workflow in a standard Logic App that reads a file content from a Windows file share. The reading is done thanks to the managed File System Connector, which is configured to use a Data ...
Germán Mendoza's user avatar
  • 25
0 votes
0 answers
162 views

I have a need to pull data from an on-premise AS/400 system and transfer it to an off-premise MySQL database automatically. I have been able to pull data from the AS/400 using an On-Premise Data ...
Targ4028's user avatar
  • 1
0 votes
1 answer
666 views

I am trying to connect to an on-premise Oracle database in order to sync some tables to an Azure SQL Server database. I believe that Data Factory is the best tool to use for these kind of bulk data ...
bobster2dope's user avatar
  • 23
1 vote
1 answer
966 views

I used a Python script in Power Query to pull data from Prometheus. It works fine in PBI Desktop, but I get the following error for the automated refresh in the Power BI service: Unable to determine ...
Ramesh Madhubhashitha's user avatar
  • 75
0 votes
1 answer
704 views

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 ...
user22354694's user avatar
  • 1
0 votes
1 answer
640 views

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 ...
Yon's user avatar
  • 13
0 votes
1 answer
808 views

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 ...
Pittsburgh_Power's user avatar
  • 1
0 votes
0 answers
1k views

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 ...
Mr. Basu's user avatar
  • 35
0 votes
1 answer
8k views

Unable to create data source.The analysis request operation is timed out before it was completed. Details: Gd Server 80: Received error payload from gateway service with ID 67805: SqlException ...
MaazKhan47's user avatar
  • 859
0 votes
1 answer
588 views

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's user avatar
  • 57
-1 votes
1 answer
100 views

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 ...
J. Mini's user avatar
  • 1,766
0 votes
1 answer
711 views

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 ...
user avatar
0 votes
0 answers
614 views

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 ...
Jonathan P's user avatar
  • 3
2 votes
3 answers
3k views

I added a logic app custom connector resource to connect to on premise HTTP API. But I'm not able to find it in logic app actions, I tried creating consumption logic app and it showed up there. Not ...
Vijay's user avatar
  • 97
0 votes
1 answer
4k views

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 ...
Pål Skønberg Løvik's user avatar
  • 425
0 votes
1 answer
633 views

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 ...
santosh kumar patro's user avatar
  • 8,343
1 vote
1 answer
2k views

I want to host a Microsoft SQL Server database. This can be anywhere: on a dedicated server or on Azure. I want to access to this sql server database from a power bi report. This report will be built ...
Bob5421's user avatar
  • 9,383
0 votes
1 answer
505 views

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 ...
Tiktack's user avatar
  • 1
0 votes
0 answers
271 views

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 ...
Mohammad Hafiz's user avatar
  • 19
0 votes
1 answer
376 views

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 ...
Mohammad Hafiz's user avatar
  • 19
0 votes
1 answer
433 views

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 ...
wilson_smyth's user avatar
  • 1,546
0 votes
1 answer
113 views

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: ...
trueorfalse's user avatar
  • 31
3 votes
2 answers
18k views

Just installed Power BI Data Gateway on one of the companies servers. The processes was smooth and very easy, I have assigned a name to the Data Gateway. As it is linked to my email (I think this is ...
asmgx's user avatar
  • 8,170
4 votes
1 answer
5k views

We are currently using an on-premises data gateway to allow our reports in the app.powerBI.com web interface use an on-premise SQL Server Analysis Services (SSAS) server tabular model for their data ...
kscott's user avatar
  • 1,946
0 votes
1 answer
1k views

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 ...
user2748366's user avatar
  • 181
2 votes
1 answer
2k views

Similar to this question. I have a .Net Core Web App that embeds a PowerBI report, this report needs has Row Level Security applied at the data level in Azure Analysis Services using an on-premises ...
Matt Stannett's user avatar
  • 2,713
1 vote
0 answers
3k views

I am trying out a Microsoft business intelligence solution which consists of a on-prem database/datawarehouse running on a SQL Server 2014 Windows server. On the same sql server is SSIS running a set ...
Geir Forsmo's user avatar
  • 149
1 vote
0 answers
258 views

I need some help here. I have published my datawarehouse database and ssis packages to a virtual machine on azure. the SSAS is in azure analysis services, and the ssis package will process the cube. ...
Geir Forsmo's user avatar
  • 149
1 vote
1 answer
2k views

I'm trying to setup a data connection from PowerApps to an on-premise SQL Server instance we have. However, I get the following error: Microsoft SQL: A network-related or instance-specific error ...
chazbot7's user avatar
  • 596
0 votes
0 answers
90 views

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 ...
H4p7ic's user avatar
  • 1,933
0 votes
1 answer
374 views

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 ...
se7vanj's user avatar
  • 160
0 votes
2 answers
1k views

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. ...
Tiklu Ganguly's user avatar
  • 357
5 votes
1 answer
5k views

I've been working with Power BI for quite a long time now and everytime I needed to use a data gateway, I used the one installed in my personal computer. But recently I was asked to host the on-...
souza's user avatar
  • 1,438
0 votes
0 answers
137 views

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 ...
Mark Rullo's user avatar
  • 1,093
0 votes
3 answers
1k views

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 -...
Arpit Kumawat's user avatar
  • 1
2 votes
1 answer
2k views

When having some on-premises data sources that one wants to access from Azure, is the "best practice" to create a data gateway, or is this becoming an outdated approach? I ask because I notice it ...
WPFUser's user avatar
  • 403
0 votes
2 answers
340 views

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 ...
souza's user avatar
  • 1,438
1 vote
1 answer
2k views

I have a SQL Server on premises which is normally used over an RDP connection. Now I'm in the process of implementing PowerBI reports and based on documentation available in MS site, I have completed ...
Prasanth Pillai's user avatar
  • 166
2 votes
1 answer
259 views

What will be used for BizTalk Server URL in creating a logic app on-premises data gateway? I used DNS of my Azure Biztalk Server VM and VM IP but it does not work for me.
Rao Adnan's user avatar
  • 1,657
0 votes
1 answer
190 views

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 ...
Guido Leenders's user avatar
  • 4,283
0 votes
1 answer
1k views

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 ...
Nicholas Patton's user avatar
  • 786
1 vote
1 answer
3k views

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 ...
Christofer Ohlsson's user avatar
  • 3,155
2 votes
2 answers
1k views

I want to connect PowerApps to my local Firebird SQL server, how do I go about it? I want to make a Pricelist App that connects to a local Firebird SQL server. Excel only permits up to 15,000 items. ...
BestFriend1's user avatar
  • 21