Forum Discussion
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.
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.
I have the same problem...repeatedly.
