Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Changing the data source from XLS to OLAP Cube (SSAS)

Hello, I would like to advise you on how to change the data source of an Excel file to an OLAP cube (SSAS). I do not want to interfere with already created reports, just change the data source and p...
Need Help
Tips and Tricks
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

For your requirement, you could use this way:

1. Copy a pbix file.

2. open the copy pbix file and then just delete all the tables (Including hidden tables)

3. Then get data from OLAP Cube (SSAS).

 

By the way, it needs  XLS and OLAP Cube (SSAS) have the same data structure(Same table name and same field name)

 

Best Regards,

Lin