This example shows how easy it is to insert Wikipedia extracts into a Power BI report using the Wikimedia API. A slicer is created to hold the name of ships, an image of the relevant ship is pulled in from Wikimedia Commons, and an extract relating to the ship is pulled in from Wikipedia. When a ship is selected, both the image and the extract update to show the details for the relevant ship.
The spreadsheet below is mentioned in the video accompanying this post.
Spreadsheet
API code
The API code mentioned in the video is “https://en.wikipedia.org/w/api.php?format=json&action=query&prop=extracts&exintro&explaintext&titles=”
This post stemmed from the creation of a Microsoft Community Data Story featured here: https://community.powerbi.com/t5/Data-Stories-Gallery/Aberdeen-Harbour-Ship-Arrivals-1914-to-1920/m-p/1993897