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

[psathanapal]

i dried to run the existing power BI desktop report, but getting below error while loading the queries,

Native queries aren't supported by this value 

please see below screen for referance.

has anyone experienced similar problem?

[Anonymous]

Hi @psathanapal 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?

Thank you very much for your kind cooperation.

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.

[Anonymous]

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.

[SamWiseOwl]

Hi @psathanapal 

When I had a similar error it was because of this setting being on:

[psathanapal]

removed the check mark for required user approvel& tried, still same issue

[VijayP]

@psathanapal 

In this particulat file the native querries are used to import data from database. you need to check which query and why it is not supported!