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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jaykwilliams
Frequent Visitor

Power BI dataset configuration - unified account

My organization uses a number of developers that regularly cycle on and off projects, and would like to centralize ownership of data configurations for numerous reports with different data sources via a single 'service' account. 

 

Does anyone have insight into the potential challenges of this desired state? We currently use a variety of data sources (including AAS, SQL db, SharePoint files) and we know that the service account would likely require access to all of these data sources. 

 

(As an aside, we currently copy our IT help desk if a data refresh fails, via the Schedule Refresh menu)

1 ACCEPTED SOLUTION

Hi there

I have implemented it in this way in the past and I have not found there to be any issues.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi there

There was a new feature where you can now add other users to the dataset failure notifications

https://powerbi.microsoft.com/en-us/blog/sending-refresh-notifications-to-others/

With regards to the dataset configuration I would go the route of a Service account.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes, we're currently using the new feature to send an email to a service account for dataset failure notifications.

 

However, there is still a strong desire to configure and manage our data sets via a service account.

 

Are we likely to experience problems if we utilize a service account in that way?

Hi there

I have implemented it in this way in the past and I have not found there to be any issues.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hello @GilbertQ 

can you provide some more details on this?

Actually I am looking to do the same for my dataset i.e. configure the scheduled refresh using a service account.

Does this mean I use "Windows" authentication and I have to login to Power BI using my service account so that it uses its credentials for windows login?

If yes, this means I also provide a Power BI license to service account.

Regards

Hi there

Yes you are correct that you would then need to use a Power BI Pro license for the service account to allow it to refresh and complete all the standard Power BI functions.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors