Forum Discussion
Live connection error
Hey Peter_23,
Yeah, I've run into this exact same headache before. Super frustrating when you rename something and everything breaks, right?
So basically what's happening is your reports are still looking for the old SM name. Even though you renamed it in the service, the reports themselves still have the old connection info baked in.
|Quick fix:- Download those reports to Desktop
- Open them up and go to Transform Data > Data Source Settings
- You'll see it's still pointing to the old name - just update it to the new SM name
- Save and republish
Or if you don't want to mess with Desktop, sometimes you can fix it right in the service by going to the report settings and updating the dataset connection there.
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Best regards,
Jainesh Poojara / Power BI Developer
Hey Peter_23,
Yeah, I've run into this exact same headache before. Super frustrating when you rename something and everything breaks, right?
So basically what's happening is your reports are still looking for the old SM name. Even though you renamed it in the service, the reports themselves still have the old connection info baked in.
|Quick fix:
- Download those reports to Desktop
- Open them up and go to Transform Data > Data Source Settings
- You'll see it's still pointing to the old name - just update it to the new SM name
- Save and republish
Or if you don't want to mess with Desktop, sometimes you can fix it right in the service by going to the report settings and updating the dataset connection there.
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Best regards,
Jainesh Poojara / Power BI Developer
thanks jaineshp TomMartens Anonymous the report is in the same workspace as SM, so pointing to new SM it worked!