Forum Discussion

ScottBeeson's avatar
ScottBeeson
Regular Visitor
10 years ago
Solved

[FAIL] Cannot edit credentials when adding an ODBC source

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.

General Comment
  • Anonymous's avatar
    Anonymous
    10 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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's avatar
      ScottBeeson
      Regular Visitor
      10 years ago

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