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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors