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.
Questions tagged [data-gateway]
43 questions
5
votes
1 answer
Power BI On-Premises Data Gateway hosted in an AWS EC2 instance
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-premises Data Gateway in a VM, so I was wondering: is…
Pedro Martins de Souza
- 1,406
- 1
- 13
- 35
3
votes
2 answers
Error when trying to configure Power BI Data Gatwewy
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 going to be another problem when other employees…
asmgx
- 7,328
- 15
- 82
- 143
2
votes
3 answers
Custom connector not found in Azure logic app(Standard)
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 getting in standard logic app for some reason. I…
Vijay
- 72
- 12
2
votes
1 answer
How do I change the server of a Power BI gateway after dozens of reports have been pointed to it?
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 source. Dozens of reports, workspaces, and other…
kscott
- 1,866
- 3
- 25
- 41
2
votes
1 answer
How to configure UPN mapping/CustomData for Azure Analysis Services and PowerBI Embedded
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 data gateway.
I have configured the…
Matt Stannett
- 2,700
- 1
- 15
- 36
2
votes
1 answer
Azure on-premises data gateway - the way to go, or overkill?
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 relies on the "Gateway Cloud Service" which as I…
WPFUser
- 403
- 4
- 16
2
votes
1 answer
What is "BizTalk Server URL" in logic app On premises gateway connection
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
- 1,597
- 12
- 19
2
votes
2 answers
Connect PowerApps to Firebird
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. I have 25,000 items. Also, I'd like for it to be…
BestFriend1
- 21
- 2
1
vote
1 answer
SqlException encountered while accessing the target data source
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 encountered while accessing the target data…
MaazKhan47
- 811
- 1
- 11
- 22
1
vote
1 answer
Working with an sql server database from app.powerbi.com without data gateway
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 with power bi desktop. But it will be published…
Bob5421
- 7,757
- 14
- 81
- 175
1
vote
0 answers
Need help getting microsoft on-premises gateway work with Azure Analysis services
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 of SSIS packages stored in the SSIS Catalog. A…
Geir Forsmo
- 149
- 2
- 11
1
vote
0 answers
Problems with running a SSIS package processing a tabular cube on azure on a virtual machine
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. I have set up an on-premise datagateway that is…
Geir Forsmo
- 149
- 2
- 11
1
vote
1 answer
PowerApps cannot connect to on-premise SQL Server through On-Premise Data Gateway
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 occurred
while establishing a connection to SQL…
chazbot7
- 598
- 3
- 12
- 34
1
vote
2 answers
Service Bus Component of Azure on Premise data gateway - Pricing
according to MS there is a Azure Service bus component to on-prem data gateway , however when you install the Azure component no service bus resource created. we need to understand the impact on pricing i.e. is the price of service bus hidden within…
Azure Ninja
- 261
- 4
- 15
1
vote
1 answer
Issue with connecting to on premise SQL Server using data gateway
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 the following,
Installed Gateway Service in a…
Prasanth Pillai
- 146
- 1
- 13