Report slow with Direct query.

[Anonymous]

Hi everyone, 

My pbix file has 3 Direct Query with an oracle statement, and wherever I do on the report, it takes a long time.

Below is the loop that I keep getting if I try to create a visual or apply a filter.

What would be the best approach to have a quick report? 
Is there anything I can do in PBI Desktop or should I try using Dataflow?

Many thanks.

[Anonymous · Accepted solution]

Hi @Anonymous ,

With no information, I could not specify what's taking so much time, but you can use the following tools:

1. PowerBI Performance Analyzer: To find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.

2. Check the datamodel and the storage mode of each table involved (ie: fact table, calendar, customer, etc).  You may refer to Composite models

3. Limit the number of objects, for each object in the dashboard a query will be sent to the datasource, limiting the number of objects might help. 

4. Use SQL Server Profiler to identify queries that are slow.

For references:

Monitor report performance in Power BI - Power BI | Microsoft Docs

DirectQuery model troubleshooting in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.