Forum Discussion

techVikas's avatar
techVikas
Regular Visitor
1 year ago
Solved

How to Allow External (Guest) Users to Access Power BI Datasets Connected via On-Premises Gateway

Hi community, I’ve set up a Power BI on-premises data gateway within my organization (domain: RCB.com) and created multiple data sources (SQL Servers, etc.) which are used in semantic models and rep...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi techVikas ,
    Guest users operate within their home tenant context, which restricts their ability to access or reuse datasets connected via your organization's gateway. Guest users cannot publish, edit, or connect to semantic models/datasets that utilize the hosting tenant's gateway unless they are working within that tenant's context.

    Refer-Considerations and Limitations

     If you dont have option/permission to switch tenant directories, consider creating a shared workspace within your tenant and adding them as members.Alternatively, you can export the necessary data to a format accessible to them or use cloud-based data sources to eliminate the need for on-premises gateways.
    Hope this helps!

    If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You!

     

     

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi techVikas

 

  • Not supported: Guests can’t reuse your on-prem gateway from their own tenant. The gateway is scoped to your tenant.

  • Two ways that do work:

    1. Build on your dataset. Give the guest Build permission (or “Allow viewers to build”) and enable B2B Direct Connect. They connect to your dataset; your gateway keeps refreshing; RLS still applies.

    2. Work inside your tenant. Make them Member/Contributor in your workspace and add them under the gateway data source’s “Users may use this data source.” They Switch organization to yours, then publish/refresh there.

  • If they must own refresh in their tenant: they need their own gateway (or move the data to a cloud source both sides can reach).

Quick checks: External sharing + B2B Direct Connect on, Pro/PPU licenses, Build permission (option 1) or workspace role + gateway user (option 2).