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..
Go to Solution.
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
Proud to be a Super User!
View solution in original post
I Appreciate your help!
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!