Data Limit? How Many Rows of Data?

[emutuc]

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 

[lbendlin]

Depends on the query mode and the capacity settings.  Default limit for Direct Query is 1 million rows.

[emutuc]

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?

[lbendlin · Accepted solution]

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.

[emutuc]

thank you @lbendlin

If i'm understanding: columns are also part of that data limt.