Forum Discussion

Peter_23's avatar
Peter_23
Advocate V
1 year ago
Solved

Live connection error

Hi community, I have a issue with a SM in the service and reports.   The SM (master) have two reports (slave) e.g live connection to master. The user rename the SM in the service, and now the repor...
  • jaineshp's avatar
    1 year ago

    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