I had a dataset that was refreshing fine.
I made a few changes in the query editor yesterday and now the following error appears when I try and refresh the report.
I closed down the file and reopened and also restarted my computer.
I have never seen this error before so any help would be appreciated.
Version 2.90.782.0 64-bit (February 2021)
Importing Excel data from SharePoint
you have a try this workaround in this similar post: