Schedule refresh for power pivot from one drive shows error

I am having the same issue.

I have done the following:

• Created a simple Excel file and set a table on my worksheet
• added table to the data model, and renamed the table in the data model to TableX
• saved the worksheet to OneDrive
• on Power BI site, connected to the Excel file on One Drive.
• the dataset sees the TableX in the data model

Schedule refresh is not allowed, error message is

               You cannot schedule refresh for this dataset because it gets data from sources that currently don't support refresh. ...

Tried using a .xslx and and xlsm files.

Additionaly tried to use a power query rather then adding table to the data model.