Have you tried using Power Query instead to retrieve the data to your model?