Forum Discussion

stesappo's avatar
stesappo
New Member
3 years ago
Solved

drill down to a database SQL query

Dear All, I'd like to know if there is a possibility, starting from a dataset in Power BI, to drill down the aggregated dataset to a database SQL query (like Oracle databasde or whatever RDBMS). It...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi stesappo ,

    If the data source is Oracle, you can refer the following link to get it by filling in SQL statement the Advanced options section just as below screenshot... Please note that Power BI Desktop doesn't support Oracle native queries that execute a stored procedure and Oracle native queries in "begin ... end" block doesn't return any result set.

    Connect to an Oracle database with Power BI Desktop

    Best Regards

stesappo's avatar
stesappo
New Member
3 years ago

So, if I've understood correctly, I can use dynamic M parameter in direct query to retrieve a dataset from a RDBMS (like Oracle) and have it as result in the Power BI in-memory database, correct?

 

Regards