How To Handle Power BI Data Refresh Error - Refresh Token Expired

Background

Power BI report users were not able to see the latest updated data in the reports so, I was refreshing data in Power BI manually but got an error to refresh the data. When your previous admin user is no longer handling the report management tasks for Power BI Service and you need to handle the tasks, you may encounter some permission issues during the transition time and need to take over some settings in the Power BI. This article describes handling the situation of data not refreshing using the manual refresh method in the Power BI service. Additionally, I will describe how to take over the authority for the dataset setting from one user to another.

When I refresh the dataset, I got an error as depicted in the below image while trying to refresh data from Power BI. For my scenario, the data source of the report was a shared excel file from One drive where the excel file was updated with new data but the report was showing only old data.

How To Handle Power BI Data Refresh Error - Refresh Token Expired

To resolve this issue and refresh the data, please follow the below steps,

Step 1

Right-click on Dataset and go to Dataset Setting as depicted below,

How To Handle Power BI Data Refresh Error - Refresh Token Expired

Step 2

Previously, the report might be managed by another user, so you need to take over on him/her to proceed with the credential setup. In the Dataset tab, you can see the Take over option as shown below.

In the below screen you can see the current user has the disabled option for Gateway connection, Data source credentials, Parameters, and Schedule refresh. So, you need to take over the existing user to get these options to enable you.

Click on take over.

How To Handle Power BI Data Refresh Error - Refresh Token Expired

Below screen will be prompted again, click on Take Over.

How To Handle Power BI Data Refresh Error - Refresh Token Expired

Step 3 - Data source Credential

Now you have permission to change datasource credentials. Click on Edit credential as illustrated below,

How To Handle Power BI Data Refresh Error - Refresh Token Expired

Select OAuth2 in Authentication Method as depicted below and click on Sign in. Previously in my case Authentication method was Anonymous.

How To Handle Power BI Data Refresh Error - Refresh Token Expired

Then you will get the below screen. Pick user or use another account and your dataset credential will be updated. You can see the message of update.

How To Handle Power BI Data Refresh Error - Refresh Token Expired

Then go back to your dataset and refresh the dataset.

How To Handle Power BI Data Refresh Error - Refresh Token Expired

Now you can see data is refreshed and reports are updated with the latest data.

Summary

Hence, this article has described steps to handle and setup dataset credentials from the Power BI service and resolve your issue when you get above mentioned Refresh Token issue in your Power BI Service while refreshing data. In the next article, I will come with how to setup Automatic Schedule Refresh in Power BI Service. Happy learning!!