Forum Discussion

lukeSDM's avatar
lukeSDM
Helper 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
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hello lukeSDM ,

 

you can check if the Excel is available. Go to the server where the gateway is running and paste the path from the report to the Explorer (e.g. C:\temp\myData\myExcelFile.xlsx). If it is not available this could be one reason.

Also make sure the Gateway can connect to the internet. Check in Power BI Service if you can see and configure the gateway.

 

Anyway I find it strange, usually you should receive a more detailed error message.

 

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
 
lukeSDM's avatar
lukeSDM
Helper 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
    Most 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