Have you tried using Power Query instead to retrieve the data to your model?
Be as you wish to seem
Forum Rules