We are receiving the error "Preview.Error: The type of the current preview value is too complex to display." in Power Query Editor.
The table that is giving the error has worked up until sometime over the last few days. The table is just one table of our larger datawarehouse in Amazon Redshift. The table in question only has 28 columns and 238 rows. The column datatypes are bigint, varchar, and timestamps.
We tried with the existing dataset to refresh, replace, clear cache with no success.
We also created a new dataset and chose only that table but received the same error. If we cancel the refresh and then drag the columns onto a report grid the data looks correct. The issue is that this table needs to be used in conjunction with other tables in the Query Editor and the Preview Error prevents that.
We do not see anything abnormal when selecting records through any SQL client.