Onelake datasource (Datawarehouse) is showing up as a SQLserver datasource within on-premise gateway

Hi LuukSteenbergen,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We really apologies for the inconvenience, after reviewing the issue of one lake data source data warehouse is showing up as a SQL server data source within on premises gateway, here are few steps which may resolve the issue.

• Navigate to power bi service → click on settings → manage connections and gateways. Identify the one lake data warehouse source incorrectly classified under the on-premises data gateway as sql server. Remove this incorrect mapping and ensure that the one lake data warehouse is not configured under the gateway. Save your changes to apply the updates.
• Please remain in the power bi service and navigate to settings → manage connections and gateways → cloud connections. Ensure that the one lake data warehouse is listed as a cloud data source and mapped to default.
• If a one lake data warehouse is missing, please re-add it by clicking add data source, selecting azure data warehouse / one lake data warehouse, setting authentication to single sign on, and clicking save to apply the changes.
• Please navigate to the power bi service and go to the datasets section. Select the dataset associated with the power bi report, then click on settings and scroll to data source credentials. Ensure that the on premises sql server is mapped to the gateway and that the one lake data warehouse is mapped to the cloud connection with single sign-on enabled.
• If there are any mistakes, please update them accordingly and apply the changes. In the dataset settings, navigate to the scheduled refresh section. Enable the refresh option and click refresh now to test. If successful, proceed to schedule periodic refreshes as needed.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Best Regards.