We are in unique situation where I am required to import a table from one of the tables Fabric to on prem sql server (SSMS). I was wondering if I could use pipeline without any gateway issue (which has been the case when we tried to load data from on prem to fabric). Other option would be to import as flat file but looks like it drops few cells in few columns and I do not want that to happen.
Any help would be appreciated. Thank you!