Forum Discussion

mw123's avatar
mw123
Frequent Visitor
8 years ago
Solved

Native Database Query Error

Hello-

 

I am getting an error when refreshing a table in PowerBI stating the following:

"This native database query isn't currently supported".

 

I have already unchecked the checkbox under Options-->Security--> "Require user approval for new native database queries".  I still get the same error with this unchecked. 

 

Does anyone know what might be still causing this? 

 

Thanks!

Need Help
  • zoloturu's avatar
    zoloturu
    8 years ago

    mw123,

     

    Could you just add simple SELECT 1 FROM some_table after UPDATE statement in Native Query? 

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    just click retry, you'll get a prompt. shikina

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      wowww!

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    Hi there

    What is your Source database? I have queries running from SQL Server and Oracle in the past with no issues.
    • mw123's avatar
      mw123
      Frequent Visitor
      8 years ago

      SQL Server is the source. It ran successfully for multiple days but now the error is occuring. 

      • zoloturu's avatar
        zoloturu
        Memorable Member
        8 years ago

        Hi mw123,

         

        Let me know if you receive this error in Power BI Service/Desktop/both?

         

        Can you give a screenshot of your SQL query? Or provide a list of SQL commands you use (SELECT, CAST, EXEC etc.)

  • pthapa's avatar
    pthapa
    Post Patron
    2 years ago

    Hello all,

    I am trying to connect power bi dataset via stored procedure in SQL server and this gave me an error, how can I resolved this issue?

    see error below.

    Thanks

    pthapa