Redshift Native Queries Suddenly Not Working

[dyungaitis]

A large number of my Power BI reports are set to pull native queries from my Amazon Redshift data warehouse.  Suddenly as of this week, every time I try to update a query (without changing any connection settings or parameters) I get this error:

Expression.Error: Native queries aren't supported by this value.

It seems that something has changed this week.  I am able to create a new connection with the exact same settings with the same native query with no problem.  But if I then go and edit that query I have the same problem.

This is really ridiculous.  Any help?

[v-henryk-mstf]

Hi @dyungaitis ,

Is the configured port number occupied when a query for an error message occurs? Is it ensured that the execution environment is not affected?

Also, for more details, you can read related document:

Power Query Amazon Redshift connector - Power Query | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.