Can you load and store data into an SSAS Cube?

Chase G 21 Reputation points
2021-03-15T18:32:25.477+00:00

Hello,
I need to find a way to load data into an SSAS cube (preferably tabular) which can then be opened on a different computer (via USB transfer).
Is it possible to "store" data into cubes and then open them on different devices via power bi?
Or do the cubes always need to have a connection to the data source( SQL server datawarehouse).

Any help is appreciated.

C

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,260 questions
0 comments No comments
{count} votes

Accepted answer
  1. Darren Gosbell 1,471 Reputation points
    2021-03-15T21:45:31.093+00:00

    If you are using import mode you do not require a connection to the data source except for when you are running a refresh operation. You can back up a tabular "cube" and restore it on to another SSAS server and then query it on that other machine. But both machines would require a SQL license and would need to have SSAS Tabular installed for this to work

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,821 Reputation points
    2021-03-16T08:02:47.817+00:00

    I thinks offline cube will also work for this requirement, that you could use Excel to open and view the data.
    But this works only with OLAP database for now, not tabular.
    See : Work with offline cube files

    0 comments No comments