Forum Discussion

Pavan_123456789's avatar
Pavan_123456789
Helper III
1 year ago

Assistance Required with Query Performance Issue

I am currently facing an issue where the DAX query runs successfully with SQL Server as the data source. However, when using a data flow as the source, the query exceeds the time limit. Could you pl...
"Need Help"
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Pavan_123456789 ,

 

In general, Dataflow handles query differently than SQL Server. Often the choice is to use DirectQuery with dataflow.


If your data source is a large dataset, you may choose to build aggregated tables into the model to improve performance and retain detail data where necessary. Please note that this only applies to Premium or Premium Per User as you need to be able to turn on Enhanced Compute Engine Settings for Dataflow.

 

For more details, you can refer to below document:

Using DirectQuery with dataflows - Power BI | Microsoft Learn

Premium features of dataflows - Power BI | Microsoft Learn

User-defined aggregations - Power BI | Microsoft Learn

 

Best Regards,
Adamk Kong

 

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

 

  • Pavan_123456789's avatar
    Pavan_123456789
    Helper III
    1 year ago

    HI Anonymous 

    Thank you for your response.

    I wanted to clarify that I currently have the option to use only the Pro license.

    If you have any suggestions or additional information regarding this, I would greatly appreciate it.