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
pang22
Helper III
Helper III

Auto refresh in workspace

Hi,

 

I have created a public workspace and added other account (B) as admin.

I have added (B) account to login the Data source credentials.

When my powerbi account deactivated, will the powerbi dashboard still auto refresh in this workspace? 

 

pang22_0-1731295563406.png

pang22_1-1731295710975.png

 

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @pang22 - If your Power BI account (Account A) is deactivated, it may impact the data refresh functionality in your public workspace, even if you've added Account B as an admin.

Here are some points to consider:

Data Source Credentials and Ownership: Data source credentials are often tied to the account that originally configured them. If Account A was the one that set up the data sources and credentials, deactivating this account may invalidate the authentication tokens associated with the data sources, causing scheduled refreshes to fail.

Account B’s Role: While you have added Account B as an admin, being an admin does not automatically grant the ability to update or inherit the credentials set up by Account A. Account B would need to reconfigure and authenticate the data sources in their own Power BI credentials to ensure that the scheduled refreshes continue to work.

Re-authentication: To ensure continuity, have Account B go to the workspace settings and re-authenticate all data sources under "Data source credentials." This will update the credentials to use Account B’s authentication instead of Account A’s.

Automated Refreshes in a Shared Workspace: As long as Account B has admin rights and re-authenticates the data sources, they should be able to maintain and control the scheduled refresh settings, even if Account A is deactivated.

Alternative Solution - Service Principal: For a more robust solution, consider using a service principal for authentication. This would allow data refreshes to be tied to an application rather than a user account, reducing dependency on individual user accounts.





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

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @pang22 - If your Power BI account (Account A) is deactivated, it may impact the data refresh functionality in your public workspace, even if you've added Account B as an admin.

Here are some points to consider:

Data Source Credentials and Ownership: Data source credentials are often tied to the account that originally configured them. If Account A was the one that set up the data sources and credentials, deactivating this account may invalidate the authentication tokens associated with the data sources, causing scheduled refreshes to fail.

Account B’s Role: While you have added Account B as an admin, being an admin does not automatically grant the ability to update or inherit the credentials set up by Account A. Account B would need to reconfigure and authenticate the data sources in their own Power BI credentials to ensure that the scheduled refreshes continue to work.

Re-authentication: To ensure continuity, have Account B go to the workspace settings and re-authenticate all data sources under "Data source credentials." This will update the credentials to use Account B’s authentication instead of Account A’s.

Automated Refreshes in a Shared Workspace: As long as Account B has admin rights and re-authenticates the data sources, they should be able to maintain and control the scheduled refresh settings, even if Account A is deactivated.

Alternative Solution - Service Principal: For a more robust solution, consider using a service principal for authentication. This would allow data refreshes to be tied to an application rather than a user account, reducing dependency on individual user accounts.





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

Proud to be a Super User!





Helpful resources

Announcements
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.