Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Using a gateway to refresh data

Our users are publishing more and more reports using datasets with the PowerBi gateway and their Active Directory users for authentication.

With our password policy the credentals exire regularly and some users have a lot of datasets they need to refresh manually with their new password.

Datasets are for now mostly Excel files on a share. Is their a more business-way to do this?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Anonymous - If your users are using data gateways in personal mode, you should consider installing one or more data gateways in standard/enterprise mode. This will allow you to configure data connections in a central location and use a service account. Also, you should probably consider more of a centralized or golden dataset model. See my article on Power BI Usage Models:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Usage-Models-in-Pictures/ba-p/1342820

 

I always recommend at a minimum 4 separate Power BI service accounts:

  • Power BI Tenant Administrator
  • Power BI Publisher
  • Power BI Gateway
  • Power BI Data Access

The names should be self explanatory for what they are used for. In terms of best practice, each data source should have its own data access service account.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@Anonymous - If your users are using data gateways in personal mode, you should consider installing one or more data gateways in standard/enterprise mode. This will allow you to configure data connections in a central location and use a service account. Also, you should probably consider more of a centralized or golden dataset model. See my article on Power BI Usage Models:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Usage-Models-in-Pictures/ba-p/1342820

 

I always recommend at a minimum 4 separate Power BI service accounts:

  • Power BI Tenant Administrator
  • Power BI Publisher
  • Power BI Gateway
  • Power BI Data Access

The names should be self explanatory for what they are used for. In terms of best practice, each data source should have its own data access service account.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@Anonymous , You can use a service account on the gateway. See if that can work for you

 

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-service-account

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.