Forum Discussion
[Help Plsss!] Daily Report Export into Compiling excel file
I have a dashboard I am creating that contains the daily cash amounts received from clients. The report I am working with is displaying the total cash amount for the current day. My goal is to someh...
Easiest way to do this is to publish your dataset, set up daily refresh, make a paginated report connected to that dataset, subscribe to it daily and have it emailed to you, and use a flow to write that file to a SharePoint/OneDrive location with filename for that day. You can then combine all those files in a new Power BI dataset to analyze daily snapshot data.
Pat