Migrating from SQL database to Azure Analysis Services database

[jmc]

I have a Power BI workbook that is currently connected to an Azure SQL database. I have imported data in the current file. When I try to change the connection to an Azure Analysis Services database, I receive the following error:

As this workbook is fairly extensive, I am hoping there is a way to update the connection to AAS without having to create everything from scratch.

I have tried deleting all of the table/data, deleting permissions saved in the file and I still get the same error

[v-chuncz-msft]

@jmc,

You may check code in The Advanced Editor and take a look at this post.

[jmc]

I have a Power BI workbook that is currently connected to an Azure SQL database. I have imported data in the current file. When I try to change the connection to an Azure Analysis Services database, I receive the following error:

As this workbook is fairly extensive, I am hoping there is a way to update the connection to AAS without having to create everything from scratch.

I have tried deleting all of the table/data, deleting permissions saved in the file and I still get the same error