cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nipius Regular Visitor
Regular Visitor

Session ID cannot be found.

Hi there!

 

I have created a dataset in Power BI, which I've linked to Excel via the Microsoft Power BI Publisher for Excel. It works fine until I stop using the pivot tables for several minutes. If I then want to use a pivot table again, it gives me the following message: "The "AAD44836- et cetera" session ID cannot be found. Either the session does not exist or it has already expired". The "et cetera" is course not the actual value. 🙂

 

It looks like at some point the connection between Power BI and Excel seem to go idle or in hibernation mode.

 

When I try changing the pivot tables two or three times, it seems to restore the connection again.

 

Is this something I can prevent from happening?

4 REPLIES 4
Highlighted
Community Support Team
Community Support Team

Re: Session ID cannot be found.

Hi @Nipius 

Which do you mean "I stop using the pivot tables for several minutes" ?

Which is the data source of the power bi report you connect to from excel?

You could check this article :

https://docs.microsoft.com/en-us/power-bi/publisher-for-excel#connect-to-data-in-power-bi

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Nipius Regular Visitor
Regular Visitor

Re: Session ID cannot be found.

Hi @v-juanli-msft 

The Power BI report uses data from an SQL server and several Excel reports on my computer. I use DirectImport to create a datamodel which I then connect to Excel. I've created several pivot tables that I update everytime I'd like to show data for a different employee ID. 

When I open the file, Excel updates the pivot tables without any issues. But when I then look at the output for some minutes and decide to change the filter to a different employee ID, I get the notification I referred to in my initial post. Only after trying to change the filter two or three times, it seems the connection with Power BI has been restored and then it works again without any issues. Until I stop changing the pivot tables for some minutes again.

redmeg74 Frequent Visitor
Frequent Visitor

Re: Session ID cannot be found.

I have the same problem...repeatedly.  

prokhorovd Frequent Visitor
Frequent Visitor

Re: Session ID cannot be found.

I have the same problem too

 

The 'XXXXX-XXX-XXX-XXX-XXX' session ID cannot be found. Either the session does not exist or it has already expired

 

An error can occur when updating any dataset and by accident. I did not find any dependencies. About 2-3 errors occur on 800 dataset`s updates per day

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)