ERROR: Changing from On-Prem Live Connection to a PBI Premium Live connection

[nimishnagpal13]

Problem

I am trying to replace the existing dataset that is a LIVE Connection dataset (on an On-Premise Analysis Server), with the dataset connection to another LIVE connection type (on Premium Capacity). While doing so getting the following error.

Reproduce the error:

Infrastructure in Use

• Workspace in Premium Capacity.             
• PowerBI Desktop Latest Version.

Actions:

1. Created a PowerBI Report on PBI Desktop. Use connection Type “Analysis Services”. Connection string.

CONNECTION SUCCESSFUL. PUBLISHED on Premium Workspace.

That’s how it looks on the PowerBI Services Premium Workspace

1. Update the Dataset with the different connection strings, which is also a Live Connection type.

• Get Workspace Connection :     Go to Setting of the workspace ->  Premium

• Use this Workspace connection in the same PBIX file.       

CONNECTION SUCCESSFUL.

• While publishing the report to the same Premium workspace, accepting to replace the dataset, it gives an error.

Analysis :

When I replace the On-premise Analysis Server with the On-premise Analysis Server, the above step (Replacing the dataset) works fine.

But when I want to switch from On-Premis Analysis to the PBI Premium Analysis Server, it gives an error.

I am able to update the datasource of the same report on the Desktop report BUT unable to publish/replace the report dataset on PowerBI Services.

THIS SHOULD BE BUG.

[GilbertQ]

Hi @nimishnagpal13 

I have been through this in the past and when the connection changes from SSAS to Power BI Premium it also changes the underlying dataset guid. 

The only way around this is to give the new report a new name and upload it.

Or what you can do if you use apps is to schedule a time where you can delete the current report, upload the new report with the same name. Then update the app.

Yes, the report links or bookmarks will be different because essentially this is a new report. But if people navigate using the app to them it will work as expected.

[nimishnagpal13]

Thank you GilbertQ for your response.

I have tried this approach in the past. This is applicable when you have 1 or 2 reports linked to the SSAS Dataset.

But in my case, there are many reports (80+ pbi report) that are linked to 1 dataset and I have to switch them over to PowerBI Premium Models.

In fact, there are quite a few PBI Service reports also linked to this SSAS dataset, which cannot be downloaded and modified manually, due to the limitation on the reports created on the PBI Services.

I believe there should be a solution Microsoft should provide, as they are recommending to move to PowerBI Premium from AAS & SSAS. There will be a lot of businesses that will face the exact same problem very soon in future.

Kindly take this as a bug.