Forum Discussion

lukeSDM's avatar
lukeSDM
Icon for Helper V rankHelper V
5 years ago

Excel data sets not refreshing and no error given

When trying to manually and automatically refresh my excel data sources using the gateway, it fails after around 30 mins but does not give me any errors. All I get is the cluster info , activity and...
Need Help
lukeSDM's avatar
lukeSDM
Icon for Helper V rankHelper V
5 years ago

selimovd 

 

I have now halfed the size of my dataset and it still fails without any error message.

 

Could broadband effect this?

 

My client has very slow and unstabel broadband.

 

 

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey lukeSDM ,

 

did you try the things I suggested?

 

It depends. How big is the Excel spreadsheet and how complex is your query? When you use a flat file like Excel Power Query has to load the whole file and then do all the transformation. So if you have a 1 GB Excel file and you just use one column, Power Query still has to load 1 GB and then remove everything except for one column.

Whereas with a relational database your transformation would be translated into an SQL statement and only one column would be selected for example (= query folding).

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis