The following process could be carried out by a Power BI Pro user authorized to use the gateway for the SQL Server database:
- Publish the DirectQuery Power BI Desktop file (dataset) to an App Workspace in the Power BI Service.
Publishing a DirectQuery dataset from Power BI Desktop
- Power BI automatically configures the dataset to use a gateway by matching the data sources configured in the PBIX file and the sources configured in the Power BI Service for the gateway. The user must also be listed for the gateway.
- Access this App Workspace in the Power BI Service and from the datasets list click on Settings ...