Can't refresh a Data Set from Excel file

[Gnoom]

Hello,

I have uploaded an .xls file (with Power Pivot data models and Power Query connections to csv and xls files) to OneDrive and from there to Power BI, but I am not able to refresh the data set. When I click on "schedule refresh" I get the error message below - could you please explain what I am doing wrong?

You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model.

[BraneyBI · Accepted solution]

In your Excel file, are the Power Queries writing to the data model, just back to an Excel table or both?

From your error message, It looks like you are using PQ to only write back to Excel.  If you click on the "Load To" option on your Power Query, can you also "Add it to Data Model"? 

Then re-save the file, and see if you can refresh it from PowerBI.com