Missing data and wrong dates appearing in report

Hi, 

I am missing data and have wrong dates appearing in my report, can anyone provide any ideas on what I can do to fix it?

Missing data

I have Xero practice manager connected by API, in one of the tables is a list of all the jobs. I can see/search for the jobs in data tab, but it is not appearing in my report. Due to the 1000 reports in the preview I am unable to see what the info looks like in the transform data/power query part.

Report

This shows how many jobs there are in the selected filter

Despite having 58 jobs, only one job is showing up. 

The filters are set to include all jobs that are not completed or internal, techincally the number in the box should match how many records appear in the table

Wrong Dates

On the same report, I have a last time entry field. 

In the transform data, this date comes from the timesheet table, sorted by date decending and then removed duplicates and merged into the jobs table bia a unique job number.

The date in the data set is correct (when viewing by the data tab), but on the report it shows a random date. 

Please note: for the jobs table, I have a couple of other tables merged into one table to create the dataset I am after for the report (Im not using any measures or related tables)