Forum Discussion

Hussain's avatar
Hussain
Icon for Helper I rankHelper I
5 years ago
Solved

Save 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 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

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