Update (Sep 24): Microsoft moved the custom Visuals to AppSource site. All my old queries to Office Stores cannot be refreshed, since Microsoft redirect the Office Store requests to AppSource. The good news: I was able to web scrap AppSource, and will share portions of the queries in my next blog post (Subscribers will get the files as well). If you are interested in the full solution (as seen in the embedded report below), including the bulk-download, go here,
Have you ever wanted to keep ALL the latest Power BI Custom Visuals in a local folder? Now you can!
In my last post, I shared a method to bulk download all the Custom Visual Sample files. Following your comments in the last post, you asked for the option to bulk download the actual custom visuals (.pbiviz), so here you go – You can now refresh and run the macro in Custom Visuals.xlsm (Shared in my Github project here). The results – A nice new folder with all the custom visual files ready for harvest.
In Data tab, click Refresh All, and wait till the refresh is done. Then, click on the button, and the bulk download will start. You can check your local PBIVIZ and PBIX folders, to see how gradually the folders are populated with new files.
Please remember – It is always better to download the custom visuals directly from Office Store.
Hope you find it useful – And If you do, please share in the comments below why, so others will know. For example, one may want to provide all custom visuals to his corporate IT security team, to run the corporate Anti malware software on these files. I surely had some false positives when I used custom visuals in the past.