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

Thank you for your advice and experience!

Need Help
Tips and Tricks

1 Reply

  • 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