cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Archive monthly reports with comments

Hi there, 

We have reports that are based on datasets. The datasets are to be updated monthly (schedule refresh). Additionally we want to store the historical reports for each month including comments. The difficulty is that when the dataset is updated, the reports from previous months are also updated.

Is there a way to cut the connection to the dataset for the historical reports and freeze their current data to archieve them including the comments?

Or does someone have an idea how to implement this with as little manual effort as possible?

Thanks in advance!

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @Anonymous ,

 

Based on my test, you can achieve the purpose with the following steps.

1# Use Download the .pbix file feature.

1.PNG

2# Rename the .pbix file and publish it to Power BI Service.

You should do these two steps each time before or after your dataset is refreshed monthly.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

4 REPLIES 4
v-jayw-msft
Community Support
Community Support

Hi @Anonymous ,

 

Based on my test, you can achieve the purpose with the following steps.

1# Use Download the .pbix file feature.

1.PNG

2# Rename the .pbix file and publish it to Power BI Service.

You should do these two steps each time before or after your dataset is refreshed monthly.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

Hi,

 

A totally different approach to this use case would be to use OneNote for the commenting and storing these report "archives". If you hit ctrl + p on a power bi page you can directly save a printed snapshot of the report to onenote.

 

Obivous cons of the work around:

- the archive will be printed copies of the report pages - no filtering or other possibilities

- must do the printout manually each month

Anonymous
Not applicable

How about incremental refresh and filtering based on the date? Could that be another solution? 

And does incremental refresh work with a SAP BW connection?

 

Thanks for your help!

Hi @Anonymous ,

 

Not sure if the incremental-refresh is suitable for your scenario. You can check the document below for more details.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#limitations

Limitations

Currently, for composite models, incremental refresh is supported for SQL Server, Azure SQL Database, SQL Data Warehouse, Oracle, and Teradata data sources only.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors