Trouble trying to refresh excel data model with local tables

Anonymous — Tue, 27 Nov 2018 15:43:45 GMT

Hi,
I'm trying to set up a scehduled refresh for an excel worksheet. However, since adding two local tables (stored in the same worksheet) to the data model the scheduled refresh ahs stopped working and I can't do a manual refresh on the data either.

Here is the error I get when trying to refresh the data.

Something went wrong
Workbook refresh failed. See details for more information.
Please try again later or contact support. If you contact support, please provide these details.
Failed Connections: Query - Budget
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: 795ab948-1569-413e-838a-969fe87efda0
Request ID: 69b8ce3a-e0ee-2200-9ef3-1ff26c84d2c1
Time: 2018-11-27 15:23:57Z

Rikard

topic Trouble trying to refresh excel data model with local tables in Report Server

Trouble trying to refresh excel data model with local tables