I recently encountered an issue with Power BI that many others may need help with. It’s been a while since I created a report using a Power BI desktop. I created a new report and got the data from another Power BI data set. My purpose was to export the data to Microsoft Lists. When I tried to access my published reports, I received a frustrating error message: ‘Cannot load model.’ This problem also affected previously created reports I created a while ago.
After some research and troubleshooting, I found a solution to this issue, which I’d like to share.
Problem:
When opening a Power BI report in the browser, you may encounter the error message:
Cannot load model. Couldn’t load the model schema associated with this report. Make sure you have a connection to a server and try again.
Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DMTS_OAuthTokenRefreshFailedError
Underlying error message: AADSTS700082: The refresh token has expired due to inactivity. The token was issued on 2023-04-27T05:32:45.0248787Z and was inactive for 90.00:00:00.
Or there will be a prompt in the report:
It looks like the refresh token expired. Please go to this dataset’s settings page, and reenter the {CredentialType} credentials for the {DatasourceType} data source.
Solution
To resolve this issue, follow these simple steps:
- Go to your workspace and select the data set created.
- Select the ‘…’ then Settings.
In the Datasets, you will see all the data sources under the Data source credentials.
- Edit the credentials of all the data sources. Leave the authentication method by default and privacy settings. Select Sign In.
- It will prompt the sign-in dialog box and sign in using your credentials.
- After updating your credentials, refresh your reports.
SUMMARY
You can find additional information and a detailed explanation about this problem.
Please let me know if you have any questions or need further assistance. Happy building 🙂