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,245 questions
0 comments
Accepted answer
  1. Darren Gosbell 1,466 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 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