How do you change login credentials for a DIRECT QUERY dataset?

I created a dataset connecting to a database and going directly to the database (DIRECT QUERY). I need to change the connection credentials. I can’t find a way to do that without re-creating the dataset?

Hi @pyi -

The database credentials are kept in the DataSource rather than the DataSet. You can update your credentials by following the steps outlined here Editing a database data source

A great way to understand more about the structure of QuickSight resource types is to look at API operation request/response syntax. See CreateDataSet and CreateDataSource.

1 Like