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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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 FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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