Provides the ability to run a query written for Wikidata and create a dataset from the output for import into Power BI.
Taking Wikidata relating to the location of where ships were wrecked off the coast of Scotland UK and plotting these locations on a map provided by esri which shows oil & gas licencing blocks on the UK Continental Shelf. This provides an example of how easy it can be to combine two different resources into one map.
Note: This report has been created purely to demonstrate how datasets from distinct providers can be combined on a map. The accuracy of the underlying data has not been checked by the report owner. Also note that the locations are where the ships were wrecked, it does not mean that the ships are still there today.
R required to be installed on local computer along with required R package.
In Power BI ensure 'R scripting' is set up in 'Options'
Required R package
R code used in example
The pbix file attached contains third party data and third party resources. Their terms of service and licensing requirements should be respected and compiled with.