Will the structure be consistent every time? You can look at Dataflows to bring data in on a scheduled interval. You setup all your transforms in Power Query once and then it will run automatically on a refresh interval to get new records.
--- Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.