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

[Anonymous]

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 publish the report to the BI Service.

Thank you for your advice and experience!

[v-lili6-msft]

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