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.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.