Historical Count of Rows Based on Refresh

[ferbyrez]

Hi guys !

First at all, thanks for helping me!

So,  I have a database on Sharepoint connected to my power bi.

It´s an aproximately 500K rows today.

But every time I refresh it increases the number of rows. Example:

1/feb/20 = 500.000

2/feb/20 = 501.000

3/feb/20 = 504.000

4/feb/20 = 507.000

I was doing this manually by creating a table in Excel and filling the lines like above..

But I want to know if is it possible to make this automatically in Power bi..

It is going to create a table counting the number of lines for each data (A historic Data| Number of rows).

Hope I could explain it properly..

Many Thanks!

[PhilipTreacy · Accepted solution]

Hi @ferbyrez 

PBI can't store data like this but there are options.

Check this thread for ideas to solve your problem

Solved: Re: Save measure result in a table everyday using ... - Microsoft Power BI Community

Regards

Phil

[ferbyrez]

I Appreciate your help!