Forum Discussion

psathanapal's avatar
psathanapal
Frequent Visitor
2 years ago

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

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?

 

5 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    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!

     

    • psathanapal's avatar
      psathanapal
      Frequent Visitor

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.