Forum Discussion
Data Limit? How Many Rows of Data?
Well, there is that murky corner of "artifacts vs rows". Sometimes you see statements like "Oh, we meant 1 million artifacts, ie rows times columns" when the text says "1 million rows". But there isn't a lot of clarity in this area.
Depends on the query mode and the capacity settings. Default limit for Direct Query is 1 million rows.
thank you @ibendlin for the reply. I use Azure as my data source. I changed query limit from auto (recommended) to "Azure" to "No limit" and I still receiving the same limits.
In the advanced editor, i have the "take" set to 1M and time stamp as far as back as 7 days, but i am only getting 2 days of data. Do the number of columns in the database affect the data limits as well?
Well, there is that murky corner of "artifacts vs rows". Sometimes you see statements like "Oh, we meant 1 million artifacts, ie rows times columns" when the text says "1 million rows". But there isn't a lot of clarity in this area.