Forum Discussion
Can't refresh data on BI Service
Hi, the reason for this is simple - you can not access your xls from PBI service without any kind of gateway installed.
I guess I found the exact topic with answer to your question here: https://community.powerbi.com/t5/Service/Help-Scheduled-refresh-not-working/td-p/553454
I suggest using a Stanard Mode Gateway.Do not forget to install the gateway with the same account as your PBI service (so it links together).
Once the gateway is installed, add your file(s) or a folder as a source to your gateway (via manage gateways - add data source) or you could simply add your xls file as a new source (get data - ....).
Also you could incorporate a dataflow for an automatic refresh (up to 8x a day in a Pro licence).
You don't necessarily need a Gateway to access your Excel workbook. If you store it on any "web based" data store and access it from there you don't need a gateway installed. Often the simplest option is to put the Excel file on to OneDrive for Business, see Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
Hope this helps
Stuart
Hi Burningsuit,
I stored in Onedrive but still can't refresh the dataset on powerBI service.
I need to refresh the report that I've published frequently without need to republish everytime I have updated the excel. Thank you