Could you please check the version number of your Excel?
Please go to Excel > File > Account > Product Information, share the version name and version number with us.
It's recommended to perform an Online Repair for Office from Control Panel.
I also suggest you run Excel in Safe Mode to have a check, that hold down the Ctrl key while starting Excel. When Excel asks you if you want to start in safe mode, please say Yes and release Ctrl key.
Safe mode could help us troubeshoot the add-ins and startup iterms.
Besides, it's recommended to try following steps to have a check.
- Create your query. In "Load To", select "Only Create Connection", do not check "Add this data to the Data Model".
- Insert a new pivot table on a blank tab of your worksheet. Select "Use an external data source" and select the connection only query you created in step above. Check "Add this data to the Data Model".
This will create a second query which places the results of your connection only query in the Data Model. - After the new query has been loaded, you can optionally delete the tab containing the pivot table.
If there is any update, you could let me know.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.