08-31-2018 04:46 AM
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?
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) Version126.96.36.1994
08-31-2018 05:37 AM - edited 10-25-2018 06:46 AM
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?
01-08-2019 02:48 AM
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.
Please act Microsoft!