Error in Report connecting to Premium dataset "Couldn't load model"

[saini_chandni]

I am working on migrating AAS cube to Power BI Premium dataset and followed instruction from document mentioned below:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools#deploy-model-projects-...

I was able to migrate cube to dataset  and it is refreshing sucessfully(working as expected till this step)

Now we have some existing Power BI Reports connecting live to AAS cube and I am swapping live connection to now connect to premium dataset by following below steps in Power BI Desktop:

Transform data > Data source settings->New workspace as server name and dataset as database->Publish

After publishing the report to new Server:

1) Report is giving error in Power BI service on opening and error says:

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

2) Publishing report also publishing dataset(name same as report) with the report which i am not expecting.

Please guide on how to swap live connection with premium dataset in existing Power BI Report and how can i resolve the report error in Power BI Service that report should work fine and connect to Power BI Dataset.

[GilbertQ · Accepted solution]

Hi there

The awesome guys at PowerBI.Tip have created a tool that can do this for you.

Here are the details: https://powerbi.tips/2020/08/hot-swap-report-connections-external-tools/

[saini_chandni]

I was not able to download it, as downloading external tools is blocked in our org but i was able to resolve it by following instructions on this link

https://powerbi.tips/2020/05/hot-swap-power-bi-report-connections/

So thanks for giving me direction, i am marking it as resolved.

[GilbertQ]

Pleasure glad to assist.