Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Gateway connection

Hi,all   I want to delete the personal mode gateway and connect with the gateway installed on the server. My coworker installed gateway on the server and told me to check the data sources. But I ...
Need Help
Tutorial Requests
PC2790's avatar
PC2790
Community Champion
4 years ago

Hey Anonymous ,

 

You will have to follow the below steps so that you can view the gateway.

  1. Check if the gateway is showing as connected under Power BI service->Manage Gateways (the gateway should show as connected to the user who installed it)
  2. Add the User’s Database or Data sources as a datasource under the configured gateway through Power BI service
  3. Add the User to the User list, in order to use the data source to create or update report

Refer - Add or remove a gateway data source - Power BI | Microsoft Docs

3 tips to avoid a missing gateway with Power BI - Guy in a Cube

Solved: Add New Users to Gateway Cluster - Microsoft Power BI Community

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your answer.

 

My mannager said I have a role in this workspace so I'm a user
But I can't see the gateway in here ,then I'm not user this gateway?

 

How can I find the gateway?
Also I can't find Gateway list at the New data source page like below.


please Let me know what the problem 

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    Your coworker who installed the gateway in the first place should be doing the steps mentioned above.

    As yo were not responsible for creating the gateway, you will not be able to see anless and until your details are added by your coworker.

    Your coworker can refer this to do it

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks to you, I solved it. It is now possible to connect to the gateway.


      However, new error occurred.
      Is this error caused by out of memory?
      If you know, please reply.
      ----------------------------------------------
      Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [08P01] server closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbefore or while processing the request.\n\r\nERROR [08P01] server closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbefore or while processing the request.\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=PostgreSQL35W"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Dim_notification_ch_campaign.