Last week, Microsoft moved Office Store to App Source. As a result, all of the custom visuals of Power BI are now available in the new site. As promised here, today I will share the main query (M code) that I used to web-scrap AppSource website. You can use the query below to build your own Power BI Custom Visuals catalog, or create a lovely alternative exploration of the custom visuals in a Power BI report like this one:
If you are a subscriber of DataChant, you can get the report above for free. You will find it under the name Custom Visuals AppSource Free.pbix in the subscribers folder (Folder link will be sent to you by email after you subscribe, and in the periodical email updates).
The free report is missing the highlighted elements below (which can be obtained in the paid version – Learn more here).
Both versions can be published to the Power BI service and support scheduled refresh. Here is the embedded version of the paid report that is auto-refreshed:
Here is the Power Query M expression you’ll need to web-scrap the Power BI Custom Visuals from AppSource. The code include some hidden gems that deserve a separate blog post (will be published soon). For example: You can use the List.Generate below to create a while (true) loop with a condition.
1- While (true) loops in Power Query.
2- Step by step walkthrough – How I scraped AppSource.
3- Bulk download of the Custom Visuals pbiviz files from AppSource (Hint: Use the query above with the VBA code I shared here).
What would you like to learn next? You can share in the comments below.
Nice code, but some IDs are definitively duplicated. It seems that MS is permanently changing the order. Thus, some visuals appear on both pages. 🙁
Hope this issue was resolved by Microsoft by now. Some Visuals appears randomly on both pages, instead of other Visuals. As a workaround, you can duplicate the queries and append the results. Then, remove the duplicates.
Thanks for the article.I got an idea to web scrap google play store android apps. Could you tell me what are the things needs to be covered ?
I would first check if you are not violating any user license agreement by scraping their site. Then I would evaluate how often they may change their website. If there are constant changes in format and UI, I would probably not even try it.
Thanks for the “JSON-trick” – very useful!
This no Longer works any more – can you help with the code that can get a list of ID’s for the visuals
Microsoft made some changes in AppSource that prevent to get a consistent list of IDs (sometimes the call will work. Other times you will receive an error). I have moved to a different technique and use an API to extract all visuals. You can order the PBIX here https://shop.datachant.com/products/govern-your-custom-visuals-in-power-bi
Thanks Gil – can you give a pointer to the code that can give a list of ID’s 🙂
Please send me an email to firstname.lastname@example.org