AWS Redshift string column type and Direct Query i PowerBI desktop

Hello Krystian_overga ,

Could you please share your applied steps for redshift data in Transform data. I can give more correct comments. However, I assume that you applied steps that some of them doesn't fold for example replace error, remove duplicate cannot fold. Whenever, you use the steps that cannot support query folding, Power bı wants to switch direct query storege mode to import mode.
More information about query folding:
https://learn.microsoft.com/en-us/power-query/query-folding-basics
https://medium.com/microsoft-power-bi/boosting-power-bi-performance-with-query-folding-techniques-751550171663

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |