Connecting Wikidata to Power BI using R
Description Provides the ability to run a query written for Wikidata and create a dataset from the output for import into Power BI. Example 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. Prerequisite 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 WikidataQueryServiceR R code used in example Disclaimers: 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. Pauline Cairns
COMPARTILHAR
Olá, Pessoal, Quero compartilhar meu painel na web mas a conta pede um administrador... E mesmo seguindo toooodos os vídeos do youtube, não consegui compartilhar meu painel... O que preciso é compartilhar apenas a visualização e filtro de forma que não seja necessário login e senha.... Alguém tem um caminho fácil??? ou até incorporar em alguma plataforma que tenha a funcionalidade que precisoMap with connecting lines
Description This visual uses Maps package and Geosphere package to draw a map of Australia and dots on that map finally connecting them with lines. Using sample migration statistics data from different cities within Australia to the city of Melbourne, R visual shows the trend of migration by color coding the lines and shading higher count cities on top of the lower ones. Prerequisites (The sample .pbix files won't work without installing the following) 1. Install R Engine Power BI does not include the R engine. Therefore, a seperate installation is required to install R on your local computer. Required R Packages Maps Geosphere Tested on MRO 3.3.1, CRAN 3.3.1
