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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
ols
Frequent Visitor

New user here - Data import in Power BI using Service account instead of name user

Hi,

 

I am new to the community as well as new to the Power BI environment.

 

I need help understanding best practices for scheduling data imports to Power BI. In my case, we are bringing data from SAP BW on HANA.

Obviously, we want to control how many calls are made to the BW servers during a window of time, and we have some stories and dashboards that need to be available every day at the same time. 

We also don't want to use an Admin user or a collaborator user to schedule the loads because if those users leave, we will have failures everywhere, impacting our SLAs. 

I am wondering how other companies control this so we can plan ahead and avoid interruptions in the loads due to inactive users, as well as be able to monitor loads to ensure successful completion.

 

Thanks for the help!

 

Orlando

2 ACCEPTED SOLUTIONS
collinq
Super User
Super User

HI @ols ,

 

The best bet on the userid is to create a Service Account with a permanent password that has the appriopiate permissions to the data and to Power BI and then you use that Service Account to run the queries.  That will resolve the inherent issues of using individual userids (ie. password changes, role changes, organizational departures, etc).

 

As for the number of calls made to the BW server, you can control that with the number of scheduled refreshes that you make in the Power BI service settings for that dataset.  Your license will determine just how many of those you can do a day but you can make it as few as once a day or perhaps set it for some strategic hours of the day or whatever you need so that you manage the data pull and the data need.  if once a day refresh is sufficient for your users, then only do once a day - no need for an hourly pull in that situation.

As for monitoring, when you schedule the refresh their is an option to send a notification on an error.  You can set that notification to key stakeholders so it won't be missed.




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

ols
Frequent Visitor

Thanks, @collinq , for our Public workspaces. We do only one load a day after the DW has completed the loads from the source systems. I appreciate your prompt and sound advice and will work with the team to implement your approach.

I believe some other users do refreshes every hour for some RT dashboards in our Distribution Centers, but those are less usual and are part of our Departmental Workspaces.

Thanks!

 

Orlando

View solution in original post

2 REPLIES 2
collinq
Super User
Super User

HI @ols ,

 

The best bet on the userid is to create a Service Account with a permanent password that has the appriopiate permissions to the data and to Power BI and then you use that Service Account to run the queries.  That will resolve the inherent issues of using individual userids (ie. password changes, role changes, organizational departures, etc).

 

As for the number of calls made to the BW server, you can control that with the number of scheduled refreshes that you make in the Power BI service settings for that dataset.  Your license will determine just how many of those you can do a day but you can make it as few as once a day or perhaps set it for some strategic hours of the day or whatever you need so that you manage the data pull and the data need.  if once a day refresh is sufficient for your users, then only do once a day - no need for an hourly pull in that situation.

As for monitoring, when you schedule the refresh their is an option to send a notification on an error.  You can set that notification to key stakeholders so it won't be missed.




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




ols
Frequent Visitor

Thanks, @collinq , for our Public workspaces. We do only one load a day after the DW has completed the loads from the source systems. I appreciate your prompt and sound advice and will work with the team to implement your approach.

I believe some other users do refreshes every hour for some RT dashboards in our Distribution Centers, but those are less usual and are part of our Departmental Workspaces.

Thanks!

 

Orlando

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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