This query does not have any columns with the supported data types. It will be disable

[Samcooke]

I am connecting to Redshift and no matter what table I try to pull in and what type of fields I have I keep getting the error "This query does not have any columns with the supported data types. It will be disabled from being loaded to the model." I've tried suggestions from this forum about disabling the auto-detect data type but it still did not work. You can see that it displays in the preview and it isn't funky data. Then when I go to load it I get the error. Whats frustrating is that it was working at some point and then it just stopped. Can anyone help or point me to a resource for a solution?

[amitchandak]

@Samcooke , refer if these can help

https://community.powerbi.com/t5/Issues/This-query-does-not-have-any-columns-with-the-supported-data...

https://community.powerbi.com/t5/Power-Query/This-query-does-not-have-any-columns-with-the-supported...

https://towardsdatascience.com/power-bi-modelling-error-803856e373d1