Ignition Report Error

We are having this issue with the report when opening design and preview menu in ignition.
I am using Tag Historian Query for 3 values that is getting data from local MSSQL DB. Data Preview limit is set to 100.
Other SQL Querys are working fine.
Any idea why I am getting this error?

The preview limit is applied after the data comes back. You are experiencing a data retrieval timeout for the raw data itself. You will need to set up bounds for your queries that can actually be satisfied within the designer's hard 60-second limit.