SSAS (SQL Server Analysis Services) Tabular - Error when Processing - OLE DB or ODBC error: Server: The operation was cancelled by the user ..

The above error is caused when processing an SSAS Tabular database. NOTE:This only applies to when using MDX and an SSAS OLAP Cube to get your data into SSAS Tabular. NOTE 2:The reason that I use MDX and the SSAS OLAP Cube to get data in is for 2 reasons. · The first is that as we know it is always a lot quicker and more efficient to get data out of SSAS OLAP. · Second is due to querying the SSAS OLAP, the underlying data warehouse can then continue importing data. So that there is no load on our data warehouse.