Forum Discussion
Error: Current session is no longer valid due to structural changes in the database
Sample Files and Steps to Reproduce the Error
I have prepared 3 objects to help Microsoft reproduce this issue.
<<PM me for download link and instructions>>
File 1) Excel Sheet: "SampleData.xlsx"
- Contains 3 worksheets of small test data that is used for the tabular model source.
File 2) Tabular Model: "SampleTabularModel.abf"
- Contains 3 tables from Excel sample data and 2 perspectives (both of which contain 2 of the 3 tables).
File 3) Power BI: "SampleTabularPBIReport.pbix"
- Contains test visualizations based on the tabular model
I also confirmed that this only happens when connected to a specific perspective. When connected to "model" (i.e. the whole model), the error doesn't happen. For me, with 14 perspectives in my model, and model processing happening every 30 minutes, this is a big inconvenience for my analysts working in Excel and Power BI Desktop. A fix would be great. Please let me know if you have questions on the example, or need any more info from me.
Thanks!