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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.