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 ...
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.