PowerBI Web Service URL - Sandbox vs Production

[Decal]

I am working with our Workday Administrator who setup an ISU for my custom reports.  I am trying to connect via PowerBI.  I was able to connect just fine to the Sandbox environment (begins with https://wd2-impl-services1.workday.com), but when I go to connect to the Production environment (begins with https://services1.myworkday.com/) I get a message that I could not be authenticated.  I can't see behind the scenes, but my administrator has assured me that everything is the same including the username and password and sandbox is a full replica of production as of every Friday.  So, I'm at a loss.  Anyone come across this?  I don't know if it's a Workday issue or a PowerBI issue.

Cheers,

[amitchandak · Accepted solution]

@Decal , If this is on the desktop, change connection details using Data Source setting. Before that check in a separate file you are able to connect to the production env.

In the Data Source setting you can use clear permission to give new credentials

Or you can use Deployment pipeline, to change connection in separate workspace

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE