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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
guyatisk
Helper II
Helper II

Using service account for scheduled refresh

Can someone direct me on how to use a service account (or an AD account that we have set up as a generic shared account with an E5 license) to schedule refreshes for datasets in a workspace.  When someone is creating a power bi report under their own user AD account (all in our org have E5 licenses) and then publishes to a workspace designated for them to publish to (not my workspace), is it that ID that "drives" processing of the report?  Or where in the report creation can the SA account be used?  Does a creator need to be signed in as that SA account?  Many questions surrounding SDLC and using Power BI.  I appreciate any help, advice, links to best practices, etc.

5 REPLIES 5
edhans
Super User
Super User

The owner of the dataset can schedule the refresh. If someone else wants to do it, they will have to take it over in the dataset settings.

 

Whomever owns it must sign in to all datasources unless those data sources are managed by a gateway. If you want to manage even cloud datasources (Sharepoint lists for example) that way, you just need to set them up in an on prem gateway and give the report authors permissions to use the gateway. 

I wouldn't use a "service account" because you'd have to share that login info with the dataset owner. The gateway is the best way to go here I believe.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Thanks for the response, I appreciate it.  I think the reason this question came up is because when a user has to change their password every 90 days, it tends to break Power BI reports and it seems to be a challenge to reestablish those data connections, for some reason.  The thought was just to use a generic account whose password is complex, but also is set to never expire.

Well, no user passwords should ever expire. NIST changed their guidance years ago on this and essentially admitted the "change regularly" was a made up standard.
NIST’s New Password Rule Book: Updated Guidelines Offer Benefits and Risk (isaca.org)
The New NIST Guidelines: We Had It All Wrong Before (riskcontrolstrategies.com)

And Microsoft also recommends against changing passwords unless there is evidence the password was compromised.
Password policy recommendations - Microsoft 365 admin | Microsoft Learn




Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

LOL!  Easier said then done.  I could bring this to IT management, but I already know what their answer would be.  I worked at another similar company who made users change to a minumum 15-character password and set them to never expire.  But the password had to be at least 15 characters long.  I proposed this already and it was struck down.  (Healthcare industry)

Yeah, old habits die hard, and changing passwords seems common sense, but it is actually detrimental.

That said, when you connect to a Power BI Dataset, the password isn't stored, it is a token, and those will periodically expire, but they don't outright break when a user changes their password. The only time I've seen it break immediatly is when a user turns on or off 2 factor authentication. That will kill the token immediately.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.