ArcGis Animation doesn't update properly

Hi, thanks for taking an interest.

There were no measures, the "size" field is a numeric field in the combined query.

The only box I haven't ticked is having the latest version (I don't have admin rights and its after hours here).

I made a stripped down version of the app and removed everything except the function, the source queries (the ones I am combining) and the query that consumes the function.  I also deleted all relationships and still had the same problem.  I then deleted all visuals and the problem remains.

All of the elements are included below (note the source queries are all drawn from seperate excel files...

addFY

Let

     export = (baseName as text, fy as list) =>

       let

           ret = List.Transform(fy, each

               let

                   name = "#" & """" & Text.Replace(baseName, "$", Text.From(_)) & """",

                   t = Table.Buffer(Expression.Evaluate(name, #shared)),

                   year = _

               in

                   Table.AddColumn(t, "FY", each year)

           )

       in

           ret

in

   export

//   Table.Combine(addFY("Invoice_Summary FY to $", {2012,2013,2014,2015,2016,2017}))

There is one of these for each FY, all from different excel files…

Invoice_Summary FY to 20XX

let

   Source = Excel.Workbook(File.Contents("C:\Users\...\file with one FY data.xlsx"), null, true),

   Invoice_Summary_Table = Source{[Item="Invoice_Summary",Kind="Table"]}[Data]

in

   Invoice_Summary_Table

AllInvoices query…

Let

   AllYears = Table.Combine(addFY("Invoice_Summary FY to $", {2012,2013,2014,2015,2016,2017}))

in

   AllYears