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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors