Forum Discussion

wireless90's avatar
wireless90
New Member
8 years ago
Solved

ERROR Getting Data From Oracle function ora-00933

Hi guys help needed. So I tried getting data from Oracle sql via the function below.   Error: We encountered an error while trying to connect. SQL Command not properly ended   SQL: Select * From ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

     

    Hi wireless90,

     

    It's very not recommended to implement transation SQL Script in power bi, because that may change data in your database. SQL Statement supported by power bi when connecting to database(SQL Server, Oracle) are like this pattern:

     

    SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
HAVING condition
ORDER BY column_name(s);

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

 

Hi wireless90,

 

It's very not recommended to implement transation SQL Script in power bi, because that may change data in your database. SQL Statement supported by power bi when connecting to database(SQL Server, Oracle) are like this pattern:

 

SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
HAVING condition
ORDER BY column_name(s);

Regards,

Jimmy Tao