Forum Discussion
Data Limit? How Many Rows of Data?
My goal is to send out a report that shows data from the past 7 days. I used to be able to do this just fine. Now I am limited to data as far as 2 days back only.
Granted, we did add more parameters to measure, so there is more data points.
My question: does power bi limit the amount of data / rows you can collect?
Thank You in advanced for your continued support
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.
4 Replies
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.
