cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ferbyrez
Helper II
Helper II

Historical Count of Rows Based on Refresh

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!

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

I Appreciate your help!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!