Replacing SSAS data model with AWS Athena tables in pbix

[Anonymous]

Hi, I have several Power BI reports that consume data from SSAS data models. The organization will retire all of the SSAS and has placed the tables used in SSAS in AWS Athena. My question is ... how do I replace the SSAS data model with the tables from AWS cloud with the minimal efforts? We have about 40 pbix using SSAS data models.

Right now my approach is

1. Start a new report,

2. Get data from the new tables in AWS,

3. Create relationahips

4. Use Tabulor Editor to copy measures from the old report to the new one

5. Redo the visuals

[v-yinliw-msft · Accepted solution]

Hi @Anonymous ,

So far, as far as I know, there is no particularly easy way to refactor and migrate these two data models, and in the case of Excel, you can also use model substitution by considering changing the data source path in PowerQuery.

Here are the steps:

1. Be sure that the Preview feature : “DirectQuery for Power BI datasets and Analysis Services” is activated.
Go to File --> Options and settings --> Options --> Preview features.

2. Click on “Make changes to this model” (right corner where you see your data connection)

3. A pop up will prompt then Select “Add a local model”
4. Go to Transform Data -- > Data source settings

5. Delete your SSAS source by clicking on “Delete…”
6. A yellow ribbon will appear then Select “Apply changes”
7. Your dataset from SSAS is now all removed. Now you want to establish a connection to your Power BI dataset. Select Get Data --> Power BI dataset. You are now connected Live on your Power BI Dataset.

For more information, you can refer this documentation if it's helped.

Reports - Rebind Report In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Hope these help you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.