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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
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