I am using 'Import Data' option to get and store data in Report server. Scheduler is refreshing data after inetrval of 1 hour. In this case when I try to render Report in Report server , it takes aroung 10 seconds to load report, my .PBIX is aroung 6-7MB.
Anyone could help me to Render report fast (in 2 seconds) when I call report in Report server?
I have taken only required columns and rows from SQL Query.