Yes, you can definitely automate the exporting of Power Apps usage data so it stays up to date each month. You don’t need to manually export anything or move it into a SharePoint list unless you specifically want to store or share the data that way.
If you're using Power BI, you can connect it directly to sources like Dataverse, Azure Log Analytics, or even Microsoft Graph, depending on where your usage data lives. Once connected, you can set up a scheduled refresh—monthly, weekly, or even daily—so your dashboard always reflects the latest stats without any manual steps.
Now, if you do want to store the data somewhere for archiving or sharing outside Power BI, then yes, you could use a SharePoint list or Dataverse table. But that’s optional—it’s more about how you want to manage or present the data.
If this helped or could help others in the community, feel free to give it a like or a kudo — it helps surface useful answers for everyone!
