Data Gateway configuration

[smishra99acres]

Activity ID: c7f0e457-4ce8-4411-9478-18ce50ce8a89
Request ID: 79c6e90f-f775-b82c-364e-406a18d7d82d
Correlation ID: 987db89b-a44a-b097-53c2-25db3d83ff20
Status code: 400
Time: Thu May 18 2023 18:52:00 GMT+0530 (India Standard Time)
Service version: 13.0.20675.84
Client version: 2305.2.13839-train
Cluster URI: https://wabi-india-west-redirect.analysis.windows.net/

[smishra99acres]

Processing error: There is no available gateway.
Cluster URI: WABI-INDIA-WEST-redirect.analysis.windows.net
Activity ID: 16694635-03d3-44db-a174-dbbdc11f82bd
Request ID: 299d8de3-a053-422b-9085-98370781e1ff
Time: 2023-05-23 04:45:06Z

[v-rongtiep-msft]

Hi @smishra99acres ,

The error message you provided indicates that there was an issue with the gateway configuration. The error code is not provided in the message. However, you can collect gateway logs with additional logging enabled while reproducing the scenario. You can also check if the gateway version is up to date, as many issues can surface when the gateway version is out of date. If you haven't updated the gateway for a month, or longer, you may want to consider installing the latest version of the gateway and see if you can reproduce the issue.

If it still does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smishra99acres]

Processing error: There is no available gateway.
Cluster URI: WABI-INDIA-WEST-redirect.analysis.windows.net
Activity ID: 16694635-03d3-44db-a174-dbbdc11f82bd
Request ID: 299d8de3-a053-422b-9085-98370781e1ff
Time: 2023-05-23 04:45:06Z

[v-rongtiep-msft]

Hi  ,

The error message "Processing error: There is no available gateway" indicates that there is no available gateway to connect to the data source. You need to ensure that a gateway is installed and configured correctly to connect to the data source. You can check the gateway status and configuration in the Power BI service by going to the "Manage gateways" page. If the gateway is not installed, try to configure an on-premise gateway(standard mode) to check it again.

Setting up Power BI Data Gateway (sqlshack.com)

If it still does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smishra99acres]

[v-rongtiep-msft · Accepted solution]

Hi @smishra99acres ,

This just means you downloaded the gateway, but you need to configure the gateway in power bi service to use it, and there are tutorials in the article provided.

1. Download and install the gateway software on a computer that has access to the data source you want to connect to.
2. Sign in to the Power BI service and go to the "Manage gateways" page.
3. Click "Add gateway" and follow the prompts to configure the gateway.
4. After the gateway is configured, you can add data sources to the gateway by clicking "Add data source" on the "Manage gateways" page.
5. Select the type of data source you want to add and follow the prompts to configure the connection.
6. Once the data source is added, you can use it in your Power BI reports and dashboards.

Make sure to follow the instructions carefully and ensure that the gateway is installed and configured correctly to avoid any issues with connecting to your data source.

Setting up Power BI Data Gateway (sqlshack.com)

Install an on-premises data gateway | Microsoft Learn

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

Please read the documents.

If it still does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.