Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to see the Oracle SQL query generated by the PBI report (PBI service), I am using the Oracle database as my source and connecting using Live connection, please let me know how and where we can see the SQL Query.
Solved! Go to Solution.
Hi @Anonymous,
Here I made a test to connect to Oracle database using Direct Query in Power BI desktop. To see the query for Power BI desktop report, we can find the file named FlightRecorderCurrent.trc in the file path as below. And then use SQL server Profiler to open the file to get SQL query .
Hi @Anonymous,
Does this make sense? If yes, kindly mark the answer as solution please. Thanks!
Regards,
Frank
Hi @Anonymous,
Does this make sense? If yes, kindly mark the answer as solution please. Thanks!
Regards,
Frank
Yes that helped
Thanks
@v-frfei-msft: i am nt able to find the folder path given in the solution. can you help? struggling with the same problem.
Priya
Did you got the file path that was mentioned in the solution
No i did not get that
Hi @Anonymous,
Here I made a test to connect to Oracle database using Direct Query in Power BI desktop. To see the query for Power BI desktop report, we can find the file named FlightRecorderCurrent.trc in the file path as below. And then use SQL server Profiler to open the file to get SQL query .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |