Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
coejnot
Frequent Visitor

Is there a "backdoor" to change source on dataset?

Hello, 

We have had SSAS models, now we have deleted the model, but not the dataset in cloud. 

There is a new datset that we want the users to redirect the report source to. 

 

But now as the model of the SSAS does no longer exist the dataset fails(ofc) and it is no longer possible to change the source in the desktop file. It is not even possible to open the desktop files for the reports. 

 

My question is: 

Are there any way of accessing the source in the dataset in some kind of "back door"?  I know it is possible to separate te report from the dataset, but is it possible to get access to the source somehow?

 

These are the error messages we get:

coejnot_0-1681281629331.png

coejnot_1-1681281791553.png

 

 

1 ACCEPTED SOLUTION
coejnot
Frequent Visitor

I found it.

By opening the Archive of the zip file using 7zip or similar, you can edit the files that the .pbix consist of. 

 

Did the same with a .pbix that already was connected to the correct dataset and copied the connection from this one to the one that fails. 

 

Then it works!

View solution in original post

1 REPLY 1
coejnot
Frequent Visitor

I found it.

By opening the Archive of the zip file using 7zip or similar, you can edit the files that the .pbix consist of. 

 

Did the same with a .pbix that already was connected to the correct dataset and copied the connection from this one to the one that fails. 

 

Then it works!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.