Reply
Member
Posts: 98
Registered: ‎07-11-2017

Error: Current session is no longer valid due to structural changes in the database

On 29. Aug, I updated my validation environment to the last version of PBI Report Server (Version 1.3.6813.37954 (August 2018)) and also applied the SQL Server 2017 CU10, due to some fixes on SSAS.

 

My Sales model is a SSAS tabular database and it is updated every 10 minutes.

 

Since this last update, I've been facing the following issue in some visuals when I access the reports that consumes my Sales model. The Refresh button on Power BI tend to solve this issue, but it happens again after my model is updated.

 

The error message is "Current session is no longer valid due to structural changes in the database"´, but the only action done is a "Process Full" on some tables, and it was working with no errors since the initial release on July 2017.

 

The error seems to choose random visuals: sometimes is a few labels on report, sometimes a table or a slicer...

 

Is someone facing the same issue?

 

Capture.PNG

 

 
Couldn't load the data for this visual
Current session is no longer valid due to structural changes in the database.
Please try again later or contact support. If you contact support, please provide these details.
Request IDbf1a69e8-e350-6bb7-7dc6-a3b9ccb32d3a
TimeFri Aug 31 2018 13:30:42 GMT+0200 (Central European Summer Time)
Version15.0.2.554
 
Member
Posts: 98
Registered: ‎07-11-2017

Re: Error: Current session is no longer valid due to structural changes in the database

[ Edited ]

Well, well,

 

after writing the post, I decided to downgrade the SQL Server 2017 from CU10 back to CU3 (the version I had before), and it solved the problem.

 

Know this, I presume that this issue was caused by a hotfix somewhere between SQL Server 2017 CU4 and CU10; but I did not have time so far to discover which KB was the problem.

 

How could I report this issue to SSAS team? Anyone?

Highlighted
Frequent Visitor
Posts: 23
Registered: ‎11-04-2017

Re: Error: Current session is no longer valid due to structural changes in the database

We are facing the same issue over here; using SQL Server CU 12.

Error is raised in case a connection is set-up using a perspective instead of the (default) Model and a 'Full Process' of a tabular table is in progress.

 

See also:

https://community.powerbi.com/t5/Issues/quot-Current-session-is-no-longer-valid-due-to-structural/id...

 

Please act Microsoft!