gateway configuration
41 TopicsConfiguración de Puerta de enlace ODBC
Buenos días, Me aparce este error a la hora de realizar la conexión de la puerta de enlace para llevar a cabo la actualización programada de mis reportes. Estoy tratando de conectarme via ODBC de Power BI a la Base de Datos del ERP Oracle-Netsuite, las credenciales que ingreso son las mismas que uso para ingresar al ERP. Por favor su apoyo. Gracias. AntonioSolved782Views0likes2CommentsCode erro Gateway Compressed Data Size For Packet Exceeded Error
I'm having problems with BIs that require automatic connection to XXX. possibly due to the XXX files being large. Can anyone help me? The gateway error message follows: {"error{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","pbi.error": {"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: XXXXX ClusterURIWABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net1.4KViews0likes1CommentCan't see “Managed Connections and Gateways”
Hello! I'm trying to bring customer data from Onpremises to Fabric. Customer already installed the data gateway onprem and everything looks good. But when I Try to access the "Manage connections and gateways" from the "Resources and extensions" blade, it didn't appear (Im using a different email domain if compare to the customer email domain). i want to access this: but this is my screen: my project is blocked, Im seeking help from partner voice and fabric community!! Any insights or feedback will be appreciated.Solved2.4KViews0likes1CommentLatest release of On-premises data gateway enhancements
Last month MS has released a total of 4 upgrades to On-prem data gateway and the latest one is 3000.230.15. While checking the releases, I didn't see any data regrading the latest version in here "Currently supported monthly updates to the on-premises data gateways | Microsoft Learn" . Just want to check, anyone have idea what all new enhancements added in latest version of On-prem data gateway when compared to previous.Solved2.7KViews0likes1CommentGateway to work with Power BI Report Server
Hi, I am aware of the Power BI Gateway available for accessing an on-prem DB when you are using the Power BI Service (SaaS). However, we have a need where the Power BI Report Server is hosted in a different part of a network than the database, not directly accessible. Is there an option in the Gateway to use with a Power BI server, instead of the Power BI Service? Or any other alternate solution you could suggest? ThanksSolved1KViews0likes2CommentsGateway com banco de dados
Olá, na empresa em qual trabalho estamos como seguinte problema: O gateway está online e aparenta estar funcionando, porém quando vamos fazer a ligação, está dizendo que "O gateway ou origens de dados não estão acessíveis", abro o power bi desktop e consigo atualizar normalmente, mas no fabric acontece isso, o que posso fazer?654Views0likes2CommentsFailed to create gateway.
Hello! All my data refresh failed today so I checked the gateway, it says it is configured correctly but the gateway is unreachable due to local network connectivity problems. So I followed some of the advice from the forum and unistalled the gateway and intalled the newest version. But then I can't retrieve it using the recovery key. I tried to create a new gateway, but it is having the same error: Failed to create gateway. Please try again. Response status code does not indicate success: 400 (Bad Request) Request Id: 15f3c513-15c6-4b43-be36-c9ea95b14b4e Timestamp: 2/24/2022 12:49:35 AM +00:00 ErrorCode: PowerBIEntityFrameworkOperationException at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<EnsureSuccessfulDMMSRequest>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<CreateOrReplaceUnifiedGatewayAsync>d__2.MoveNext() I found a post having similar issue but it doesn't have a solution. https://community.powerbi.com/t5/Report-Server/Failed-to-create-gateway/m-p/822515Solved4.5KViews0likes4CommentsGateway Error
Hi All, I have a report with source as SQL. I have deployed that report in the service. To schedule the refresh for that report, it is required to install and configure Gateway. So, i tried to install the Personal Gateway first, it got installed, but unable to configure it with my account. Similalry i have tried Standard gateway also, (uninstalled the personal and installed the Standard) even then getting the same issue. Below is the error screenshot of it. The above mentioned is everything performed in one of our Servers. The same process i have done in my base machine, and it is working fine. Only issue is in the Server. Please help or provide any solution for this. Thanks, Sudharshan.6KViews0likes1CommentData gateway - Should I Install and where to install?
Good day everyone! A rookie question. My objective is to distribute completed power BI report to users through web interface. I have subscribed with Power BI Pro version. I used Power BI desktop to make the report and the deliverable is just one .pbix file that connecting to SQL Server 2012 for data source. I build the same report with both way of querying SQL server (Import and direct query). And I uploaded both reports to my workspace. Both report got error when I tried to open it in my workspace: For the one database connection is using "Import", it can display the dashboard like barchart things. But if I click on the dataset "Refresh" button it said "Something went wrong - Scheduled refresh has been disabled. Please try again later or contact support. If you contact support, please provide these details." "Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh. Cluster URIWABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net Activity ID0cb0327e-9259-4980-bcc2-68dc7a1daca7 Request IDac1a381a-5d11-939c-f94f-37e5722ffae2 Time2023-01-05 08:37:13Z" For the one database connection is using "Direct Query", it cannot display the dashboard (as no data inside). When I first click on the report it already shows a red ribbon at the top of the screen "There is no gateway to access the data source [myDBName]." as well as "Data source unreachable - There is no gateway to access the data source en02live . Verify the gateway connection configuration on the dataset settings page and make sure all required data sources are added to the selected data gateway." The current infra setup here is : - SQL Server 2012 (the data source and I use internal IP address to access to it) - My laptop with SSMS (I use this to query and create a temp table. And this is where the Power BI dashboard load data from) - My laptop with PowerBIDesktop installed (I use this to develop the report) - My workspace (that is my login under my 365 account which subscribed as Pro user) So, questions are: It seems my next step I need a "data gateway" in place. However I have no idea where should I put that gateway in? Shall I install the on premise gateway in SQL server? The gateway setup: it seems allows me to login using my 365 account. But it does not have setup to connect to my SQL server by putting in credential and ip/host name of my data source (i.e., SQL Server). How that data gateway works? If I need to distribute the report to users, do I need to get extra Pro license for them? We have at most 5 to 6 users only that need to access Power BI report. Thanks a million for all advices or sharing of link that help me to make this come true.Solved4.1KViews0likes1CommentConnecting SAP DWC via ODBC to power BI
We were trying to establish a connection from SAP DWC to Power BI using ODBC.We were able to import model from DWC to Power BI desktop .After publishing the dashboard created using the imported model, is it possible to maintain a connection from Power BI service to DWC through ODBC by creating a gateway connection? The objective is to maintain a sheduled refresh to fetch data from DWC. Is it feasible to use ODBC in that manner?826Views0likes1Comment