Connect and collect data separately from each table. Once this is done, first check all tables are having your expected data or not.
If you found all tables containing expected data, you can now create a new table using Append option in power query. This new table will contain all data together as per your expectation.
Remember, in preview mode not all data shown always if there are big amount of data in the source. You will get the complete list in table visual in the report.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…