by the way, I got the same behavior by adding the password in the workbook XML.
Interesting. Now, are you able to schedule a refresh that runs successfully? I'm wondering if Embedded Credentials is 'turned off' on the Server that the Server will strip out or ignore embedded credentials. So it would enforce the setting regardless of embedded credentialing within the workbook.
<edit> Dang, logged-in using wrong credentials. I just got a new laptop. I gotta fix that.
I haven't try the schedule. I will try it.
But im able to create a workbook and use that published datasource without need to inform the database credentials.
Sent from my iPhone
I couldn't perform the refresh, just "live connection".
But I could perform the extract with the Desktop using the datasource published on the server.
Thanks for checking.
I'm not sure if this is a security flaw or not. Maybe a work-around?
yes, it seems a workaround to bypass this specific server permission.