Forum Discussion

pennyhoho117's avatar
pennyhoho117
Icon for Helper IV rankHelper IV
1 year ago
Solved

enable 'Use an On-premises or VNet data gateway' option' setting in power BI report

 

we have a use case:

two colleagues A and B,  A is worksapce Admin, B is member,

A installed gateway on his local device, B havnot.

when A publish report to the workspace, A can go to Gateway and cloud connection and enable 'Use an On-premises or VNet data gateway' option , then map the report to the required data source, while B cannot enable the ''Use an On-premises or VNet data gateway' option, it is dimmed.

 

Need Help
  • pennyhoho117's avatar
    pennyhoho117
    1 year ago

    hi,

    we checked with Colleague B, it is work now, may i know when we change permission for Data gatway and Data Source, it is not effective immediately? because we did not change anything, but  Colleague B told us it is work today and not work yesterday.

    and 

    about the Dataway and Data source permission:

    if a user published a Report, and wants to map the report to a existing data source, what permission should the user have? <Data source permission: User? no any gateway permission needed?>

    and other users who view/ edit the report content, dont need to have any data source credential right?

4 Replies

  • pennyhoho117's avatar
    pennyhoho117
    Icon for Helper IV rankHelper IV
    1 year ago

    to give some udpates, i have check even give colleague B Workspace Admin right, Data gateway admin right, 

    the ''Use an On-premises or VNet data gateway' option still dimmed. Can you give some advices.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi pennyhoho117 

    If the "Use an On-premises or VNet data gateway" option is grayed out in Power BI Service, it is typically due to permission or configuration problems. The initial step is to verify whether the user has been specifically added to the gateway in the Manage Gateways section under the Users tab. Even if the user has access to the workspace, they still require explicit permission to use the gateway.

    Moreover, having access to the gateway is insufficient; the user must also have the necessary permissions to use the particular data source within the gateway.

    Thank you.

    • pennyhoho117's avatar
      pennyhoho117
      Icon for Helper IV rankHelper IV
      1 year ago

      hi,

      we checked with Colleague B, it is work now, may i know when we change permission for Data gatway and Data Source, it is not effective immediately? because we did not change anything, but  Colleague B told us it is work today and not work yesterday.

      and 

      about the Dataway and Data source permission:

      if a user published a Report, and wants to map the report to a existing data source, what permission should the user have? <Data source permission: User? no any gateway permission needed?>

      and other users who view/ edit the report content, dont need to have any data source credential right?

  • dlehonkov's avatar
    dlehonkov
    New Member
    3 months ago

    Our report sourcing data from Databricks 

    What has helped me to enable Use an On-premises or VNet data gateway option is in the PowerBi Desktop 

    i neede to open Advanced editor for each table 

    and in the source use tags in the Source line 


    M Query example 

     

    let
    Source = Databricks.Catalogs("<YOUR_DATABRICKS_HOST>", "<YOUR_HTTP_PATH>", [Catalog=null, Database=null, QueryTags=null, EnableAutomaticProxyDiscovery=null, Implementation="2.0", Protocol=null]),
    hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
    generic_Schema = hive_metastore_Database{[Name="<YOUR_SCHEMA_NAME>",Kind="Schema"]}[Data],
    generic_Table = generic_Schema{[Name="<YOUR_TABLE_NAME>",Kind="Table"]}[Data]
    in
    generic_Table