Forum Discussion
Cannot Publish Dataflow (sourcing data from Excel SharePoint)
You could take a look at the limitations that we have today in Dataflow Gen2:
Data Factory Dataflow Gen2 limitations - Microsoft Fabric | Microsoft Learn
For the issue that you're reporting, it commonly only appears if you're using a Gateway. Are you currently using a gateway for that dataflow? if yes, please let me know if the article below works for you:
You can check the article below to get more information on how to check the gateway used for your dataflow (if any):
Change the gateway used in a dataflow project - Power Query | Microsoft Learn
- Thanks. I clicked options and it says Gateway - none So there is no gateway it appears. It's a fairly simple query, that sources from a Sharepoint folder, form a table in an excel file. When I run this in Excel itself it takes about 5-6 minutes. Just a little surprised it is "forcibly closing the connection from the remote host" I've tried refreshing about 5 times... so am just giving up until MS get back to me.
For Excel files with the .xls or .xlsb extension, you need a gateway to make things work (as there's a dependency on a driver that needs to run in the gateway to read those files).
If your files do not have any of these extensions, then do please reach out to Microsoft's Support Team by raising a support ticket. Below is the link where you can raise a support ticket to engage directly with the engineering team: