Data request to server failed... Analysis Services query error.
This error shows that your MDX in this report is big. It gets time out when it requests data from the server.
You can login Modeler -> Click on Server Setup button -> Server tab -> Query time out, by default it's 30 secs. You can set it longer here.
But this error only happens on some reports, which means those reports are with heavy MDX, not a good way to build the reports.
We highly recommend to check the attached guidance word file. It shows how you should build your reports better.
Further error message:
- Click the Microsoft Office Button, and then click Excel Options.
- Click Trust Center.
- Click Trust Center Settings.
- Click Macro Settings.
- Click to select the Trust access to the VBA project object model check box.
- Click OK to close the Excel Options dialog box.
- You may need to close and re-open excel.