Save measure result in a table everyday using DAX

[Hussain]

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.

[PhilipTreacy]

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 · Accepted solution]

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