Is there any issue with dataflow

[tannhq]

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.

[otravers · Accepted solution]

This may or may not explain what you're seeing, but be aware that dataflow performance has been all over the place for weeks now, it's a known issue and Microsoft support has announced it should be fixed by July 21st:

- https://powerbi.microsoft.com/en-us/support/

- https://docs.microsoft.com/en-us/power-bi/troubleshoot/known-issues/known-issue-dataflow-on-premium-...

[solvisig]

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]

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]

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

[tannhq]

Thank you,

I know the problem, because the locale.

Different locale between Dataflow and dataset.

Thanks,