Access on premise Gateway

Hey Smokey24 ,

I'm a little confused, this is due to the following.

You are mentioning Power BI Report Server, you have to be aware that this is the on-premises "variant" of Power BI Service, you can read more about this here: https://powerbi.microsoft.com/en-us/report-server/

If you are using Power BI Report Server, you don't need a gateway, as everything is on-premises.

A gateway bridges the communication between the Power BI Service that is located on Azure and your on-premises data sources.

Ask your Power BI Service Administrator to add a connection to your on-premises data source, and add you to the users that are allowed to use this connection:

• https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem (general)
• https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial#connect-a-dataset-to-a-sql-server-database (specific, how to set up a connection to a SQL Server database)

Hopefully, this helps to tackle your challenge.

Regards,

Tom

Stay safe, stay healthy, and happy holidays