Forum Discussion

andrewjones11's avatar
andrewjones11
Regular Visitor
4 years ago
Solved

Can't refresh data on BI Service

Hi,   I use and excel workbook to provide my dataset and can refresh it without issue in Power BI desktop. Once published, I am unable to refresh the data and get the following error:    Data so...
Need Help
  • TomasD's avatar
    TomasD
    4 years ago

    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).

TomasD's avatar
TomasD
Frequent Visitor
4 years ago

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).