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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
StanislawWisni
New Member

Not possible to edit data source in .rdl file?

Users have issue with accessing reports it gives this error:

 

StanislawWisni_0-1752576968529.png

 

Semantic model refreshes fine - fixed as ther was issue because original owner leaved the company. But still the same error. If I download .rdl file there are no option to edit credentials for it at all:

StanislawWisni_1-1752577049003.png

 

If i run report in Report Builder - same error.

According to copilot i need to recreate or reports in that case? I hope its a joke ?

 

 

1 ACCEPTED SOLUTION
ToddChitt
Super User
Super User

I don't think you need to recreate the entire report. You should be able to create a new Data Source in the .rdl file, then edit the Datasets to point to that new source.

But be careful how you authenticate that Data Source. You may need to set it up with saved credentials that get used regardless of who is running the report. If you want the end user's credentials to get passed through to the Data Source, that is going to be a bit harder.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
ToddChitt
Super User
Super User

I don't think you need to recreate the entire report. You should be able to create a new Data Source in the .rdl file, then edit the Datasets to point to that new source.

But be careful how you authenticate that Data Source. You may need to set it up with saved credentials that get used regardless of who is running the report. If you want the end user's credentials to get passed through to the Data Source, that is going to be a bit harder.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Worked thanks 😄 a lot of manual work but finally user is happy as it was important report

 

Cheers

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors