Native queries aren't supported by this value - getting this error while loading queries in power BI

Hi psathanapal 

This error often occurs when there’s a problem with the SQL query or the way it’s being executed in Power BI.
Ensure that your SQL query is correctly formatted. Even a small syntax error can cause this issue.
Make sure you’re using fully qualified names for your database objects (e.g., Database.Schema.Table).

Here are some links for your reference:

SnowFlake & PowerBI "native queries aren't support by this value" - Stack Overflow

Solved: "Native queries aren't supported by this value." W... - Page 2 - Microsoft Fabric Community

Best Regards

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