After enabling BigQuery export in Firebase, it takes a few hours for Firebase to create the dataset. After that, BigQuery/Firebase Ad Revenue connector could be linked to the app.

If the dataset is not created in a few hours, disable then re-enable the export setting again.