When getting data from Catalog (either to verify clinical users onto appropriate courses or as a bulk to process the data through Power BI) I would go Catalog > Analytics > Users, then close the monthly filter and then export the CSV and then use the emailed CSV.
This could happen every day and is time consuming and a bit of a pain.
In a ideal world I would have that CSV exported every day at 1am and put into a folder where it overwrites the previous version. I'm not sure if there is an easy way to do this?
I assume this would have to happen with API called, I know little about this process and was hoping I can use Power Automate to do the work for me. Is this good approach?
I ran into a problem where I want all data ever from Catalog no matter if the courses were live or deleted. Then it looks like you might have to have an API call with Catalog and Canvas. Then potentially get really confusing.
Has anyone had experience with this or any good ideas to resolve my issue.
Thanks for any help in advance.
