Forum Discussion

tannhq's avatar
tannhq
Helper I
4 years ago
Solved

Is there any issue with dataflow

I create a dataset from dataflow. But this morning, I try to add 1 column in datafow and now  it takes 30' to refresh data. I use import mode.    
Dataflow
Need Help
solvisig's avatar
solvisig
Advocate III
4 years ago

Adding one column can increase refresh time by this much if the granularity level of that column is very high.
You can use vertipaq analyzer to analyze the granularity level of your columns 🙂

Br,

tannhq's avatar
tannhq
Helper I
4 years ago

Thanks,

I just need 2 minutes to refresh by PBI desktop, but I don't know why it takes more than 30' to refresh on PBI service. 

  • solvisig's avatar
    solvisig
    Advocate III
    4 years ago

    Then it is possible that yout data gateway is becoming a bottleneck for refresh performance.

    • tannhq's avatar
      tannhq
      Helper I
      4 years ago

      Thank you,

      I know the problem, because the locale.

      Different locale between Dataflow and dataset.

       

      Thanks,