question

ChaseG-5638 avatar image
0 Votes"
ChaseG-5638 asked ·

Can you load and store data into an SSAS Cube?

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DarrenGosbell-0123 avatar image
1 Vote"
DarrenGosbell-0123 answered ·

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

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered ·

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


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.