You can't schedule refreshes for this report because it has no Data Model.


  • It is a power query and I have quite a few others that are working fine since the recent update.  On this particular sheet I get the no data model error.
    Friday, June 06, 2014 12:35 PM


  • hi, did you add the PQ query to the model?

    There is a checkbox for you to indicate where the table is loaded to:

    An existing one you can add to the model via the PowerPivot ribbon, by selecting Add To data model.


    Friday, June 06, 2014 7:33 PM