Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Please advise specific instructions on how it is possible for data from an on-premises SQL server database to be fed into a Lakehouse.
When using Gen2 dataflow to connect to on-premises SQL server via a gateway (client using Power BI Premium), configuring a Lakehouse as the data destination does not work:
If I use a Gen1 dataflow to connect to the on-premises SQL server, and then reference the result of this dataflow using a Gen2 dataflow, interface (most of the time) allows for the Lakehouse to be assigned as the data destination, but then the Gen2 dataflow fails to refresh and gives the following error:
When above dataflow is referenced in a pipeline, the associated run fails and below error message is received:
Trying to connect to the on-premises SQL Server database via a pipeline does not appear to be an option as the only available connection method is "Basic" and there is no option to select the gateway.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @ericmarshall ,
Given that it is still a preview feature, based on the error message you provided, Power BI is currently not supported at this time.
Community Support Team_Caitlyn