Alternate for PIVOT in Direct Query

[Ramesh4321]

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 alternate for PIVOT.

Thanks in advance,

[amitchandak]

@Ramesh4321 , Use Matrix to get the pivot , if that can solve.

Or Create that in database