Alternate for PIVOT in Direct Query

Hello All, I am using the direct query to fetch the data from Azure SQL server into PBI and using the PIVOT in sql query. Query is taking 8  hours to fetch the data. Please suggest if there is any ...