45 questions
0
votes
0
answers
49
views
Is it possible to connect a PowerBI report to an Excel file using a Virtual Network Data Gateway?
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 ...
0
votes
1
answer
106
views
Case sensitivity in file name and extension in managed File System Connector using Data Gateway
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 ...
0
votes
1
answer
645
views
Linking On-Premise Data Gateway to Azure Data Factory
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 ...
0
votes
1
answer
690
views
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 ...
0
votes
1
answer
798
views
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 ...
0
votes
1
answer
7k
views
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 ...
-1
votes
1
answer
100
views
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 ...
0
votes
0
answers
612
views
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 ...
0
votes
1
answer
4k
views
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 ...
1
vote
1
answer
2k
views
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 ...
0
votes
0
answers
270
views
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 ...
0
votes
1
answer
426
views
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 ...
3
votes
2
answers
18k
views
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 ...
0
votes
1
answer
1k
views
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 ...
1
vote
0
answers
3k
views
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 ...
1
vote
1
answer
2k
views
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 ...
0
votes
1
answer
363
views
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 ...
5
votes
1
answer
5k
views
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-...
0
votes
3
answers
1k
views
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 -...
0
votes
2
answers
332
views
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 ...
2
votes
1
answer
256
views
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.
0
votes
1
answer
1k
views
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 ...
2
votes
2
answers
1k
views
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. ...