Forum Discussion
Compare Daily Snapshot? Maybe by Journal, WriteBack, or Recording Results?
Sounds like you'd like to get periodic snapshots of your data, which isn't a feature in Power BI. However it can be done in at least two ways that I know of. Both are a little tricky, so it is not an easy solution (but it is doable for the initiated).
1. Publish your dataset and set up refresh. Make a paginated report, publish it, and subscribe to it. Use a flow to get the CSV, XML, or Excel file attachment from the email and store it (and name it) somewhere on OneDrive or SharePoint.
2. Create a table in query, convert it to JSON and send it in an http request to flow. Use the flow to create a CSV (or other type of file), and save it to OneDrive or SharePoint. This way may have issues setting up automatic refresh on the service (anonymous http POST request but there are some tricks to avoid that potentially with relative path, etc.).
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Microsoft EmployeeSounds like you'd like to get periodic snapshots of your data, which isn't a feature in Power BI. However it can be done in at least two ways that I know of. Both are a little tricky, so it is not an easy solution (but it is doable for the initiated).
1. Publish your dataset and set up refresh. Make a paginated report, publish it, and subscribe to it. Use a flow to get the CSV, XML, or Excel file attachment from the email and store it (and name it) somewhere on OneDrive or SharePoint.
2. Create a table in query, convert it to JSON and send it in an http request to flow. Use the flow to create a CSV (or other type of file), and save it to OneDrive or SharePoint. This way may have issues setting up automatic refresh on the service (anonymous http POST request but there are some tricks to avoid that potentially with relative path, etc.).
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat, this is a AWESOME suggestion. I was wondering if it would be doable and even experimented with Flow to learn a little bit of it weeks earlier. I had actually gotten pretty far, but I had some issue with the naming of the reports. However, now that I recall it better, the test was slightly different as I was getting the report directly from the host system rather than Power BI.
I'll give this another shot in the next day or two. However, it is very encouraging to hear that others could make it happen!