Direct Query with Dataflows - load balancing operation error

[Anonymous]

Hi, 

I am using Direct Query with dataflows and aggregation. But I keep gettin the below error message everytime I refresh my dataflows. Any suggestion what might be happening

Thanks

Nishant

[Anonymous]

Hi,

I am receiving the same error, while trying to create dataset from dataflows with Direct Query.

[Anonymous]

@Anonymous 

I have experienced that this error happens when you are trying to pull a large volume of data. I think it is restricte to a 1m rows but I could be wrong. 

[Anonymous]

Hi @Anonymous :

I doubt that as it says use direct query to work with large dataset. So you did not find any solution to this problem?

[Anonymous]

This issue got resolved  for me once i updated my PowerBI desktop

[Anonymous]

The limit is not on large datasets but the query you are running against it. If you query returns very high volume, that's where I think this error happens. I could be wrong though. 

Have you tried to query small number of rows and see if it works. You can then build from there

[Anonymous]

Hi @Anonymous 

I have connected it via direct query and in table visual, i have just added one column and after that i started receiving this error.

[v-zhenbw-msft]

Hi @Anonymous ,

Sorry for that, We cannot reproduce the issue here and also not found an effective solution.
We suggest you to open a ticket here for help: https://powerbi.microsoft.com/en-us/support/

Best regards,

Community Support Team _ zhenbw

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