Forum Discussion
Power BI Performance
Thanks GilbertQ for your responce !
I have just a question - exactly how can I find the actual Query (all the multiple qry fired by each tile from 1 page) that is being sent to SQL ? If I get I might be able to do something on new Indexing looking those where condition .
At this time new View/CUBE will not be a solution for us... only we can add new index on tables if required. So need acxtual qry sent to SQL ( Full direct Query method) .
If you want to check the query sent from PowerBI to your data base, you need to go to the SQL Server Profiler if you are using management studio from Microsoft or download this for Oracle : https://docs.oracle.com/cd/B10501_01/em.920/a96674/db_admin.htm#1013955
- Quentin
What I found is if we use only Native query then only we can use that Profiler only . We arre using Direct query with out Native query .