Queries from Access missing in PowerBI

Hi Lydia Anonymous,

thanks so much;

can i clarify; even a basic sum function wouldn't be able to flow from access into BI?
My access database has no other functions than sums, or multiplying/dividing data in a query. 

Also, to test your solution I've tried making additional queries which simply select data from other queries which used sum functions etc.  These are still not appearing in BI. 

For example; 

qry_OEE_ByLine (image 1 on left) has a function at the end to calculate a metric by adding / dividing some values. this was not appearing in BI navigator.

I then made qry_lineOEEImport (image 2 on Right) then simply selects the outputs of that into a new query.

This still does not appear in BI navigator. 

Thanks very much

Jon