Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedJoin us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now
Have you ever tried deleting multiple bookmarks in one shot? Unfortunately, I was not able to. I tried in multiple ways, but nothing worked. Firstly, there is no direct option to select all the bookmarks. We need to hold CTRL or SHIFT and then select each and every individual multiple bookmark that’s the only option to select all the bookmarks. I know it’s a lot of work. Even after that much of pain you will not have ‘Delete All’ option. 😞
Is there any other option? Well, Sadly I could not find any option on web. I went to my dear friend ‘ChatGPT’ and asked for help.
Let me breakdown all three suggestions:
So, there isn’t any other quick and easy option? Nah! I found an option, and I was able to delete 450+ bookmarks in less than a minute without losing any of my work. Here are the steps I followed.
Prerequisites:
Points to remember:
Procedure:
Step 1: Open your PBIX report file and expand the bookmarks pane. Select the bookmarks which are required and should not be deleted, in my case I would select last 5.
Step 2: Right click and group them. You can also give a meaningful name, I am naming it as ‘Don't Delete’
Grouping bookmarks
Now I do not need any other bookmark which is out of this group. Let’s delete the remaining 25 quickly
Step 3: Save the report in PBIP format.
Step 4: Open the PBIP folder with VS Code
Step 5: Navigate to bookmarks folder (). Under this folder you will find one .json file for every bookmark in the report. Name of this json file represents the bookmark id.
Step 6: Open bookmarks.json file, here you will find the list of bookmarks in the sequential order. At the end, I can see a portion which represents the bookmarks group that I have created.
Step 7: Now the task is to remove every json file which does not fall under this group.
I would suggest you delete all the bookmark.json files and move them to recycle bin and then restore those bookmarks which are required.
Step 8: In the bookmarks.json file remove all other bookmark ids expect the bookmarks under the group.
And that’s it, save the file and open the PBIP file then you will only find the bookmarks that we have grouped.
Let me know if you know any better way of deleting bookmarks in bulk.
Need a Power BI consultation? Hire me on Upwork.
Happy learning!
Tharun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.