Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We use a PowerBi dataset in Excel for daily work meaning users have the Excel file open all day, but if they do not use the file for a period of time they get below error when they are using the file:
Then the user have to press OK before they can work again in the file.
What can we do here to avoid this?
Solved! Go to Solution.
Hi , @KasperJ90
As searched in document, i do not see the session resolution, it just said that:
If you receive a token expired error, it means you haven't recently used the Analyze in Excel feature on the computer you're using. Simply re-enter your credentials, or reopen the file, and the error should go away.
For more information, you can refer to :
Troubleshoot connecting Excel to Power BI data - Power BI | Microsoft Learn
But also I find some document about token lifetime, you can try to if it may help you:
Microsoft identity platform access tokens - Microsoft Entra | Microsoft Learn
Configurable token lifetimes - Microsoft Entra | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @KasperJ90
I think the reason for this warning message is because for security reasons, Power BI has a mechanism for AAD tokens to expire periodically every once in a while, because your Excel application needs to use AAD tokens to continuously send query access data to Power BI, and when a certain period of time is exceeded, the token will expire, so this error occurs.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Can I change this somehow?
I anoys the users when they open the file and make a pivot they can not edit that pivot 30 minutes later.
Hi , @KasperJ90
As searched in document, i do not see the session resolution, it just said that:
If you receive a token expired error, it means you haven't recently used the Analyze in Excel feature on the computer you're using. Simply re-enter your credentials, or reopen the file, and the error should go away.
For more information, you can refer to :
Troubleshoot connecting Excel to Power BI data - Power BI | Microsoft Learn
But also I find some document about token lifetime, you can try to if it may help you:
Microsoft identity platform access tokens - Microsoft Entra | Microsoft Learn
Configurable token lifetimes - Microsoft Entra | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.