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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.