Issues Installing on-premises data gateway

Hi Stephen10,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to lbendlin,for his inputs on this thread.

The message “this specific request will need elevation” indicates that Windows is blocking the gateway installer because your account does not have administrator rights on your work laptop. Since an on-premises gateway installs system services, it must be installed with local admin permissions. In most organizations, only IT can approve or run those installations. I would recommend sharing this error with your IT team and asking them to either install the on-premises data gateway (personal mode) for you using an admin account or provide access to a centrally managed standard mode gateway if your organization already has one set up on a server.

At the same time, based on your screenshots, your dataset uses SharePoint Online as the data source which is already a fully cloud-based connection. For those sources, you do not need an on-premises gateway at all. Instead, you can complete the setup by going to Power BI Service → Workspace → Dataset → Settings → Gateway and cloud connections and ensuring SharePoint is listed under Cloud connections with your credentials signed in. If no on-premises systems are involved, this approach will allow refreshes to work without installing anything on your laptop.

Refer these links:
1. https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem 
2. https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install 

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help. 

Thank you for using the Microsoft Fabric Community Forum.