Forum Discussion
Power BI Performance
I would suggest ensuring that your databases is optimized for queries from Power BI. This will ensure that it can return the dataset as quickly as possible.
The potential bottleneck is that the data is being sent queries from Power BI (Which are not the most efficient) but it is the underlying database that is taking some time to answer the queries.
Also another factor is due to having so many visuals it has to send a query for each visual.
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 .
