Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Enterprise Gateway security settings - Admin VS User

Hi!

 

Do all users need to be gateway administrators to be able to use the gateway datasources?

 

Me and another user shares a .pbix file. It is on a shared drive and should be identical datasource wise.

I can publish the project to the service without problem, but when the other user publishes we get an error that the dataset can not find the gateway.

 

The other account is a user for the datasource in the gateway, but not a gateway administrator. Does it have to be?

 

 

(Edit)

It is configured for scheduled import mode.

  • Anonymous's avatar
    Anonymous
    7 years ago

    The other user was in a different (older) version of Power BI Desktop.

    Updated to the oktober release and now it works.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    The user doesn't have to be gateway administrator, after you add him as user of the data source in gateway, he can use the data source to refresh Power BI report.

    In your scenario, please make sure that if the user uses same connection string as yours to connect to the data source, and if the users adds data sources in the PBIX file.

    By the way, what is the data source?

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable

      The source is a SQL database.

      We both connect with server and database name using windows auth.

    • Anonymous's avatar
      Anonymous
      Not applicable

      The other user was in a different (older) version of Power BI Desktop.

      Updated to the oktober release and now it works.