Excel data sets not refreshing and no error given

[lukeSDM]

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!

[lukeSDM]

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!?

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[lukeSDM]

@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]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic