Using Google Sheets to show Azure Analysis Services data

We normally show data from Analysis Services and Tabulars in Excel. I have been doing this for years.

However, I am currently in a situation where the spreadsheet of choice is Google Sheets, and the data is in Azure Analysis Services. MS Office isn’t really an available option here.

Is there a way for me to use Google Sheets to show Azure Analysis Services data in pivot form like we used to in Excel?