Automatic Data Connection

Once you publish the data, a database connection is automatically created in the Canvas Studio in the name of _IMPORT_CONNECTION_. All the successive data that you import are created as data sources under this default connection.

You cannot edit or modify the configurations of this connection and its data source.


And a corresponding data source is created for the new connection with a table name appended with the string _DS.

You can create one data source by importing multiple spreadsheets one after the other. If the row and column of the database does not align with the spreadsheet structure, the database table alters itself automatically.