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
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.
Hi @nishantjaincent :
I doubt that as it says use direct query to work with large dataset. So you did not find any solution to this problem?
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
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.
Hi @nishantjaincent ,
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.
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.