Null values for calculated columns

[eliabemsn]

After the last update on 10/19, Power BI is showing null values for information from Google Sheets calculated columns (array and filter functions for example). Has someone already faced that problem? Any Google Shets connections changes on the last update?

[v-lili6-msft]

hi  @eliabemsn 

To my knowledge, there is no Google Shets connections changes on the last update.

It works well on my side, please try to refresh the dataset and check if something wrong in the Google Sheets.

and also try to use last month version to have a try.

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

Regards,

Lin