Forum Discussion

kjendro's avatar
kjendro
Frequent Visitor
5 years ago

ODC Connection Session ID for Analyze in Excel

I have a dataset published to the Service. Using Analyze in Excel to create pivot tables. Many times when I try to refresh the connection, I get a "Session ID cannot be found. Either the session does...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi kjendro 

 

This is by design because when you log into the Power BI Service there is a session token that gets created, which can expire. When using the browser there is an option which says Keep me logged in.

 

While when you are using Excel this option does not exist. What is happening when you get the error is that the session has expired and the token is no longer valid. Behind the scenes it then refreshes the token, and will then start refreshing.

 

This also ensures that security is kept up to date.

kjendro's avatar
kjendro
Frequent Visitor
5 years ago

But I do have the "Keep me logged in" option enabled in the service (because I go in it 6 times a day usually). Is there a way to hard code a token in the ODC connection properties? Getting tired of clicking "ok" on my Excel report 15 times each time I refresh.