Our data gateway only shows up for some datasets

[Kbersani]

I have installed the new on-premises data gateway and it is up and running however when I go to connect the gateway from a dateset which was previously linked to a personal gateway it does not give me an option to select "Data gateway" only the "personal gateway" optoin is avaiable.

Other datasets (used by the previous personal gateway) does have the option avaiable, the only thing I find different with this dataset is that it contains two "create table" queries.

[v-qiuyu-msft]

Hi @Kbersani,

In your scenario, which data sources used in this dataset? Do this two tables connect to the same data source or different? If data sources used in the dataset require gateway, please make sure you have created data sources under data gateway use the same connection string as in the Power BI Desktop.

Also On-Premises Gateway does not support OAuth ( like SharePoint Online ). You can take a look at this similar thread: Unable to schedule refresh with sharepoint and database.

Best Regards,

Qiuyun Yu