"This report failed to load because session state is not turned on" when you try to view Microsoft Access Services reports
When you access the reports on access web based site it throws an error This report failed to load because session state is not turned on
Enable the session state via PowerShell and that resolves the issue.
Prompts for the Database Name: <Databasename>
Example: Enable-SPSessionStateService AccessReportsDB
There is nice article from Microsoft on how to fix this.