Forum Discussion
Cannot Publish Dataflow (sourcing data from Excel SharePoint)
Hi, I've tried several times to publish a dataflow, but I keep getting the following error. It sources from a SharePoint folder, and transforms a few tables from a few excel files. It's not ...
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:
- Thanks. It is a .xlsx file, so that's not an issue either. In power query online, it loads the final table in the query chain in about 10 seconds.. I see the first 100 rows. But the refresh, after I publish it, takes about 13 minutes, then it gives that error message. I've raised a ticket with MS.