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.
Instructions
Download Custom Visuals.xlsm (Originally shared in my Github project here, but is now limited available here).
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.
Enjoy 🙂
Hi Gil, I’m really surprised to receive your gift so quickly. That’s an amazing grace to me. Thank you very much.
it’s giving me this error: visual basic runtime error ‘-2147012889 (80072ee7)’
I suspect that the error might occur due to network issues (e.g corporate firewall or web proxy restrictions). Can you try it from outside your corporate network?
The same error message…
Thank you for sharing. Can you please share your version of Excel?
Please also check if you can run it outside your corporate network.
Excel 2016 64-bit (16.0.4549.1000) – it is a corporate version and it might have something to do with firewall but the file from previous mail “landed” safely. By the way my congratulation for your “Coffee break talk about Power Query” – interesting, promising and funny.
Regards
CezarP
Hi Cezar,
I am glad you find the Coffee Talk funny. Regarding the error above – I switched a library to handle the PBIVIZ files. The old library didn’t handle the HTTP 302 redirect responses. The new library handled it. I am not sure I will have time to troubleshoot it. Hope that someone in the community will consider to contribute and improve the code. You can try to run Fiddler, capture the HTTP traffic, and send me the file by email.