We are connecting each report to an excel by a web query for easy export and work on it for other reports, but recently the HTML data fetch seems corrupted and won’t show like it used to. I used old and new version of excel, nothing fixes this. I believe the problem is with the new update of the system.
To be honest this new update created more problems for us than ever fixing or improving anything. (a team of +15 people)
Above is the old version excel web connection query, and it wasn’t suppose to show like that.
and this one is new query of excel, still doesn’t bring any data. (it used to work just fine)