Forum Discussion

PhilW's avatar
PhilW
Regular Visitor
4 years ago

Bookmark retention time after source data deletion

Hello,

I have a question regarding the retention time of personal bookmarks in the Power BI Service.
Some of my colleagues have experienced that their personal bookmarks have been deleted from the service. What we figured is that some of the underlying data, which was used in the bookmarks, had been deleted.

So here is my question:
Will a personal bookmark be deleted after some of the underlying information has been removed? If so, how long will the bookmark remain until it is deleted?

The official documentation states, that a bookmark will remain but it should result in a malfunction of the bookmark but not a deletion if underlying data has been removed.
I have tested this in various approaches confirming the documentation.

Here is some information about the setting:

The Power BI report page contains various filters and a main visual which are receiving data from connected dim & fact tables that are stored in an Azure SQL DB. The data is retrieved via direct query.

What I tried to reproduce the disappearance is the following:
1. Delete only the entry in the source table relevant for the bookmark
2. Delete the table (DROP TABLE)
3. Truncate the table
4. Re-upload a new version of the report.

All of the examples result in the outcome stated by the documentation, i.e. a malfunction of the bookmark but not a disappearance.

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi PhilW 

    As the documentation says, if you make a major change to a report, such as removing a field used by a personal bookmark, you will get an error the next time you try to open that bookmark . I also tested according to what you said, but so far it doesn't appear that the bookmark is deleted.

     

    Best Regard

    Community Support Team _ Ailsa Tao

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

    • PhilW's avatar
      PhilW
      Regular Visitor

      Hi Anonymous,

      Thank you for reproducing my tests.
      However, you also seem to be unaware of some kind of retention time after that a bookmark will be deleted when underlying data has been deleted?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi PhilW 

    Since the bookmark has not been deleted, it is impossible to determine the retention time of the bookmark after the basic data you mentioned is deleted . And I found some information related to bookmarks, and there is no mention of the cache time before bookmarks are deleted.

     

    Best Regard

    Community Support Team _ Ailsa Tao

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