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

I hve checked the gateway is online and signed in and that all my credentials are correct but still it does not refresh.

It seems as if somewhere along the line it just gives up and times out but I've ran out of ideas!

Any help is greatly appreciated!

Need Help

4 Replies

  • 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
         
  • lukeSDM's avatar
    lukeSDM
    Helper V
    5 years ago

    I think my dta set is too big but I thought I would at least get an error message!

     

    I tried with a very simple report and only 1 spreadsheet in my dataset and it refreshed through the gateway in just a few seconds.

     

    This is ridiculous can I not have big datasets just becasue I use the gateway!?