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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
KasperJ90
Helper III
Helper III

PowerBI Dataset used in Excel "expires" after approx. 15 minutes

Hi,

 

We have a PowerBI dataset that people use in Excel. The problem is that the connection "expires".
This means when a user opens Excel and connect it works, but then they need to edit the pivottable later it always gives below errors:

 

KasperJ90_0-1670246954623.png

KasperJ90_0-1670247213911.png

 

The dataset is used in Excel for daily work, so users have the filen open all day, but it drives them crazy they get the errors every 15 minutes. They need to press ok to both errors and refresh the dataset via "refresh all" in Excel. How can I fix this?

5 REPLIES 5
RufusJCat
Regular Visitor

I get what microsoft is trying to do here- they want to close out the connection to their servers. But this is really poorly executed, and it creates a horrible user experience. There is no way to "reenter your credentials" when this happens, so the only solution is to close, then reopen, the file. And it's not like the user actually re-enters credentials when reopening the file, so what is the point? Why not just reactivate the connection when the user clicks on a slicer or in some other way triggers a refresh? I know I know I know someon is gonna suggest the "idea space" or whatever they are calling it these days but really, why should we have to suggest an idea to make the product not suck so badly that it's unusable? 🙂

v-yueyunzh-msft
Community Support
Community Support

Hi , @KasperJ90 

According to the message 'The session ID cannot be found. Either the session does not exist or it has already expired', seems like when you do not use analyze in excel for some time, the session would be expoired. After closing this message, it would be 're-connected'.

 

See this similar note:Token expired error

Troubleshoot the connection from Excel to Power BI data - Power BI | Microsoft Learn

 

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.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

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

 

I can do this - but it is not a good solution for business users. 
If I save an Excel file all business users can access can I then avoid this error by some settings in the file?
The goal is that when business users open the file it is working without it expires. 

Hi , @KasperJ90 

According to my search, it seems that for security reasons, tokens will have an expiration time, and this can only be solved in this way.

vyueyunzhmsft_0-1670314220837.png

You can posy your ideas in Power BI Ideas:

Ideas (powerbi.com)

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

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

 

collinq
Super User
Super User

Hi @KasperJ90 ,

 

Are you using API;s?  Best practices for working with the Excel API - Microsoft Graph | Microsoft Learn




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

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




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors