Hi,
What version of Office did you use?
What kind of data source did you use?
Did you re-install Office recently?
Try to create a new connection from Microsoft Query, and check if this method will work.
Please be a bit more precise to explain your problem or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.