This is an interesting issue, I published a PowerBI report within a Fabric workspace. The report has 2 sources, an on-premise SQL server, which connects fine and is also recognised and accepted with the gateway i've installed. the 2nd is a DWH within Fabric(OneLake). however, the Onelake DWH source shows up as a SQLserver datasource when trying to setup the gateway connections to be able to setup scheduled refresh. (see picture) It does however. also shows it to be a cloud connection: This seems really odd to me, and i can't find the reason why this is happening, hopefully someone can help me out! TY

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.

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

Forum Discussion

Related content

DataSource not found

semantic model - get datasources

Datasource for Power BI

Remove existing DataSource

DataSource not found