Connect reports directly to server without gateway

igoff91 , You can Only work with cloud DB without Gateway. All On-premise DB need Gateway

 

If are using Azure SQL, you do not need gateway

Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk

 

 

Hi igoff91 ，

Services can generally connect to cloud data sources without a gateway. However, you might need a data gateway if your data sources are behind a firewall, require a VPN, or are on virtual networks.refer:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-faq  

 

Alternatively if your report data is a one-off and you don't need to refresh the data, you can use switch the data connection method to import. This will also allow you to view the reports, but if any adjustments are needed, you will have to republish the Pbix file to update the data.

 

And about how to configure gateway you could refer the below article:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install 

You also need to do the below operation on the service:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources 

 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien