A Power BI gateway is software that you install within an on-premises network; it facilitates access to data in that network.
Questions tagged [powerbi-datagateway]
20 questions
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
0 answers
Power BI: Dashboard refresh fails occasionally with error DM_GWPipeline_Gateway_MashupDataAccessError
I have uploaded my Power BI file in Power BI Service (Power BI online) and the source of this file is Azure Sql database and for the credentials of this database in Power Service I have set virtual network data gateways.
So the problem is that…
ISO169
- 23
- 1
- 5
2
votes
1 answer
How can we add multiple subscriptions to one On-Premise Data Gateway?
We would like to connect our Azure Analysis Services to a Managed Instance.
There are 3 different subscriptions, Develop, Pre-Prod and Production
The public endpoints on the Managed Instances are turned off. So we are using an On-Premise Data…
Koen
- 475
- 4
- 17
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 allow the azure data center IP address dynamically in firewall
I'm trying to install powerbi data gateway on-prem. So as per the pre-requisites, I need to allow some domain/IP for the outbound firewall.
As per this
It is recommended that you whitelist the IP addresses, for your data
region, in your firewall.…
Jayendran
- 9,638
- 8
- 60
- 103
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
4 answers
Power Bi Desktop- Couldn't load the schema for the database model
Power BI desktop image Downloaded the Power BI desktop version.
Installed it.
And Opened it.
This message popped up.
"Couldn't load the schema for the database model"
"We couldn't retrieve the data model for this report. Please try again."
And also…
Avishek Tiwari
- 11
- 1
- 3
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
0
votes
1 answer
Power BI reports are not refreshing because of invalid gateway credentials
My reports on Power BI service are connected to a data source which is a sql server. I added this to a gateway and scheduled a refresh every morning. I use my microsoft credentials for the connection. Now it's failing after I changed my windows…
Neri Kim
- 135
- 1
- 2
- 9
0
votes
1 answer
Power BI data refresh failed
A data refreshing scheduled process has been working for weeks in app.powerbi.com, but some days before it just stopped.
I received the following error message:
{
"error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
…
andexte
- 181
- 6
0
votes
1 answer
How Automatic Refresh of Power BI Dashboard without on-premises Data Gateway
I have some concerns regarding my Power BI dashboard. Although I have scheduled a refresh for it, I worry that if my computer is switched off during that time, the refresh won't take place, leaving my dashboard out-of-date.
Hence, I'm curious to…
Aquib Moin
- 23
- 1
- 7
0
votes
0 answers
Use Datasource from Power BI Data Gateway (PostgreSQL DB)
I would like to integrate my postgresql database as a data source into my Power BI as a basis for analyzing the database.
Since the database is internal, I installed a gateway on another server that accesses the database. I set up the gateway and…
mj_risc
- 1
0
votes
1 answer
Power BI Gateway Connection without Internet Connection
I want to connect with online power BI and create reports using Data gateway connectivity. my Problem is Internet Connectivity. I don't have the internet in the Production environment. Is it possible without the internet?
If it is possible then how?
Arvind Chavda
- 11
- 3
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
PowerBI On-Premises Data Gateway through a VM for customers?
I work in a small company and we develop PowerBI dashboards for a few clients. Data sources tend to change with each client from MySQL, MariaDB, SQL Server, Excel etc. Most clients want to setup scheduled refreshes but in order to do that we need a…
Manuel Galicia
- 3
- 1