Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Refreshing data from an excel file

Hello Power BI Novice here,    I keep getting this error.   "Refresh can't be scheduled because the data set doesn't contain any data model connections, or is a worksheet or linked table. To sche...
Need Help
Tutorial Requests
GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi Anonymous 

 

In order for data to be refreshed it has to connect back to a data source.

 

Because your data is coming from an Excel file and it is essentially being copied there is no data source connection.

 

You would need to import the Excel file into Power BI Desktop, and then configure the gateway to refresh it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks GilbertQ 

     

    I think that I currently am only utilizing the Service (it's in my browser) I'll have to speak with my Company IT department to get the Desktop version downloaded. I don't think that I can make the data connections without it. 

     

    Presto_RCP