PowerBI Gateway issue

Hi rsye ,

Please refer to the following steps to troubleshoot and resolve the gateway issue:

1. Check Gateway Installation and Service:
- Ensure that the Power BI Gateway is installed on the new virtual server where your full version of SQL is running.
- Verify that the gateway service is running on the server.

2. Update Data Source Settings in Gateway:

3. Map Users to Data Sources:
- Ensure that the users who need to access the apps are mapped correctly to the data source under the gateway's permissions.

4. Test Connection:
- After updating the data source, test the connection to make sure it is successful.

5. Refresh Dataset in Power BI Service:
- Navigate to the Datasets section in the Power BI Service.
- Find the datasets for your apps and attempt a manual refresh.
- Ensure that the refresh is using the updated gateway and data source.

6. Re-publish Reports:
- If necessary, re-publish your Power BI reports from Power BI Desktop to the Power BI Service after updating the data source settings.

I have also found similar posts, please refer to them.

Solved: there is no gateway available to access the dataso... - Microsoft Fabric Community

Solved: Re: No gateway to access data source data-but work... - Microsoft Fabric Community

If it 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.