[FAIL] Cannot edit credentials when adding an ODBC source

[ScottBeeson]

Get Data > Other > ODBC

Select data source

Enter a query if necessary

Enter credentials

Receive "Access Denied" error

Presented with "Retry", "Edit" or "Cancel"

Click "Edit"

Prompted to select DSN

Click "OK"

Receive "Access Denied" error.

No way to edit credentials, have to cancel and start over.

Rage.

[Anonymous · Accepted solution]

Hi @ScottBeeson,

In Power BI Desktop, please go to File>Options and settings>Data source settings, choose Global Permissions, then choose the ODBC source and click “Edit Permissions” to edit your credential.  There is an example for your reference.




Thanks,
Lydia Zhang

[ScottBeeson]

This is good to know but still feels like a failure from a workflow perspective.