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...
Updating the Power BI Gateway solved the issue for me.