Cannot export data to excel on a direct query report

Hi Kalpavruksh,

The problem I have is in the service, I haven't been able to find a solution yet. I have the rights to export to excel but the users that I'm sharing the report with do not.  They used to be able to export but it changed few weeks ago.

Line totals are under 30,000 and users have pro licenses, set up for the report is to export data  both as summary and underlying, but users are not even getting the option to export the data. Not sure what else to do. I shared different reports with the same users and they can export from those, the difference is that those reports are imports compared to the one that I having problem that is direct query.

Thanks for your help, but if you have any other idea let me know