The Data Provider feature needs a database range to work. If the user forgot to define a database range, or wants an another database range to be used that does not exist, he must close the Data Provider dialog and open the Define database range dialog. The suggestion is to add the equivalent UNO command for Define Database Range tied to a button on the right of the Database Range dropdown to open the Define Database Range command dialog. On closing the Define Database Range command, the name of the newly defined range should be in the Data Provider dialog "Database Range" dropdown list.
UNO command is .uno:DefineDBName SID_DEFINE_DBNAME (26328)