Very slow rendering of report and slicer drop down

[Anonymous]

Hi All,

I am using Azure SQL Database as a source, it is a direct query and it returns 45k rows, when I run the sql in SSMS it takes 11 seconds, when I run the report in PBI it takes forever and when I added slicers, it takes forever to load the data in the slicers, please advice.

Thanks

[amitchandak]

@Anonymous , Make sure yo do not have bi-directional joins. If needed create an index on join columns and filter columns

[Anonymous]

@amitchandak thanks, on my SQL Code that I am running in SSMS , it is all LEFT joins (only 6 tables), no bi directional joins, checked with my dba and he checked for any missing indices and we did not find any, all required indices in place. Like I said in SSMS it takes 9 to 11 seconds. Coming to PBI, It is the same SQL Query, no other queries or added. My two slicers are YEAR and QUARTER, my YEAR list is from 2019 to current year, so just to populate 4 values 2019,20,21,22,23 it is taking almost a minute.

Thanks