Forum Discussion
Helper ISave measure result in a table everyday using DAX
Hi Power Bi Community,
I have a few measures which record an approximate size of the different tables. I want to record/save these values in a table so that I can observe what's the size of each table everyday.
How can I copy and save these values?
I am doing this to monitor memory usage and then I have to use this data to forecast the memory requirement.
If you have a date or index column on the tables, you could calculate a running rowcount to show size historically. If not, you can't store stuff like that between refreshes in Power BI. One way would be to make a paginated report with a visual that has the row counts in the dataset, subscribe to it as csv file, and send it to Flow to save the daily files to SharePoint/OneDrive. Lots of overhead, but it could work.
Pat
2 Replies
- PhilipTreacy
Super User
Hi Hussain
PBI doesn't have persistent storage like this. Your measures will change day to day as the tables change, you won't be able to add rows to a table for example, inside PBI.
You could manually copy the table and save it to Excel or export the data from the visual.
Regards
Phil
- mahoneypat
Microsoft Employee
If you have a date or index column on the tables, you could calculate a running rowcount to show size historically. If not, you can't store stuff like that between refreshes in Power BI. One way would be to make a paginated report with a visual that has the row counts in the dataset, subscribe to it as csv file, and send it to Flow to save the daily files to SharePoint/OneDrive. Lots of overhead, but it could work.
Pat
