{"id":1855,"date":"2020-12-18T14:15:50","date_gmt":"2020-12-18T14:15:50","guid":{"rendered":"https:\/\/bi.unija.com\/en\/?p=1855"},"modified":"2021-01-13T14:22:47","modified_gmt":"2021-01-13T14:22:47","slug":"r-and-power-bi-introduction-and-examples","status":"publish","type":"post","link":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/","title":{"rendered":"R and Power BI \u2013 Introduction and Examples"},"content":{"rendered":"

For Power BI version 2.76.5678.782 (December 2019).<\/em><\/p>\n

R is a programming language for statistical analysis of data. It’s open source and supported with over 15 000 packages, covering specific areas. Alongside powerful packages it provides print quality visualization of data. Power BI supports R, opening door to unlimited data manipulation and visualization.<\/p>\n

To use R in Power BI desktop you need a local installation of R. RStudio, a scripting environment is freely available and comes with latest version of R. R in Power BI is available in two instances: in Power Query queries and as a visualization in Power BI.<\/p>\n

R in Power Query<\/h1>\n

We can use R inside a query. Incoming and resulting data is always a dataframe<\/em>. Let’s look at a simple example.<\/p>\n

Example<\/h2>\n

We have a simple table.<\/p>\n

<\/p>\n

We want to add a C<\/strong> column, sum of columns A and B. We take the following steps.<\/p>\n

Select Transform > Run R script<\/strong>.<\/p>\n

<\/p>\n

R editor titled Run R script<\/strong> is opened. Comment in first row states that incoming data is stored in a variable named dataset<\/strong>.<\/p>\n

<\/p>\n

Enter the following rows.<\/p>\n

newname = dataset<\/p>\n

newname[‘C’] = newname[‘A’] + newname[‘B’]<\/p>\n

<\/p>\n

First row creates a copy of dataset<\/strong> table named newname<\/strong>. We can’t change the original dataset<\/strong> variable, so we always make a duplicate.<\/p>\n

Second row adds column C<\/strong> to newname<\/strong> table, sum of columns A<\/strong> and B<\/strong>.<\/p>\n

Confirm with OK<\/strong>.<\/p>\n

A list of all created tables is returned. In our case it’s only one table, newname<\/strong>.<\/p>\n

<\/p>\n

Click on Table<\/strong> link. New table newname<\/strong> is opened.<\/p>\n

<\/p>\n

R and Power BI<\/h1>\n

R can be used for visualization of data in Power BI report. That’s a big advantage, since R is strongly supported with graphical packages, providing building blocks for beautiful custom visualizations.<\/p>\n

Example<\/h2>\n

Let’s look at a simple example. We have time series of currency value that we want to visualize. Table consists of many currencies (AUS, EUR, USD, \u2026), but we’ll only draw a plot for GBR<\/strong>.<\/p>\n

<\/p>\n

We take the following steps.<\/p>\n

We select R visualization<\/strong> in Power BI report..<\/p>\n

<\/p>\n

R script editor is opened.<\/p>\n

<\/p>\n

We check the fields we wish to plot. Our table consists of many columns, but we’re only interested in Year<\/strong> and GBR<\/strong>.<\/p>\n

<\/p>\n

Script editor now gets input data and prints out the following comments.<\/p>\n

<\/p>\n

Comment states that incoming data is stored in a dataframe called dataset<\/strong> and consists of columns Year<\/strong> and GBR<\/strong>. Duplicate rows were automatically removed.<\/p>\n

We enter the following commands into script window.<\/p>\n

plot(dataset$Year, dataset$GBR,<\/p>\n

main = “GBR curency”,<\/p>\n

xlab = “Year”,<\/p>\n

ylab = “GBR”,<\/p>\n

type = “l”,<\/p>\n

col = “blue”)<\/p>\n

We used plot<\/strong> function with the following arguments:<\/p>\n

    \n
  • x axis, column Year<\/strong> from dataframe dataset<\/strong><\/li>\n
  • y axis, column GBR<\/strong> from dataframe dataset<\/strong><\/li>\n
  • Title \u00bbGBR currency\u00ab<\/li>\n
  • x axis name, \u00bbYear\u00ab<\/li>\n
  • y axis name, \u00bbGBR\u00ab<\/li>\n
  • line style \u00bbl\u00ab, meaning line<\/em><\/li>\n
  • color \u00bbblue\u00ab, meaning blue<\/li>\n<\/ul>\n

    We run the script by clicking Run<\/strong> Script <\/strong>icon.<\/p>\n

    <\/p>\n

    We get the following plot.<\/p>\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    For Power BI version 2.76.5678.782 (December 2019). R is a programming language for statistical analysis of data. It’s open source and supported with over 15 000 packages, covering specific areas. Alongside powerful packages it provides print quality visualization of data.<\/p>\n","protected":false},"author":5,"featured_media":1870,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3],"tags":[10],"class_list":["post-1855","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-intermediate","tag-r"],"acf":[],"yoast_head":"\nR and Power BI \u2013 Introduction and Examples - Bi Unija<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"R and Power BI \u2013 Introduction and Examples - Bi Unija\" \/>\n<meta property=\"og:description\" content=\"For Power BI version 2.76.5678.782 (December 2019). R is a programming language for statistical analysis of data. It’s open source and supported with over 15 000 packages, covering specific areas. Alongside powerful packages it provides print quality visualization of data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/\" \/>\n<meta property=\"og:site_name\" content=\"Bi Unija\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-18T14:15:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-13T14:22:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Branka Trifunovi\u0107\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Branka Trifunovi\u0107\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/\",\"url\":\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/\",\"name\":\"R and Power BI \u2013 Introduction and Examples - Bi Unija\",\"isPartOf\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png\",\"datePublished\":\"2020-12-18T14:15:50+00:00\",\"dateModified\":\"2021-01-13T14:22:47+00:00\",\"author\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\"},\"breadcrumb\":{\"@id\":\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#primaryimage\",\"url\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png\",\"contentUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png\",\"width\":720,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bi.unija.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"R and Power BI \u2013 Introduction and Examples\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bi.unija.com\/en\/#website\",\"url\":\"https:\/\/bi.unija.com\/en\/\",\"name\":\"Bi Unija\",\"description\":\"Just another Bi site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bi.unija.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\",\"name\":\"Branka Trifunovi\u0107\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"caption\":\"Branka Trifunovi\u0107\"},\"url\":\"https:\/\/bi.unija.com\/en\/author\/branka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"R and Power BI \u2013 Introduction and Examples - Bi Unija","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/","og_locale":"en_US","og_type":"article","og_title":"R and Power BI \u2013 Introduction and Examples - Bi Unija","og_description":"For Power BI version 2.76.5678.782 (December 2019). R is a programming language for statistical analysis of data. It’s open source and supported with over 15 000 packages, covering specific areas. Alongside powerful packages it provides print quality visualization of data.","og_url":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/","og_site_name":"Bi Unija","article_published_time":"2020-12-18T14:15:50+00:00","article_modified_time":"2021-01-13T14:22:47+00:00","og_image":[{"width":720,"height":480,"url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png","type":"image\/png"}],"author":"Branka Trifunovi\u0107","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Branka Trifunovi\u0107","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/","url":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/","name":"R and Power BI \u2013 Introduction and Examples - Bi Unija","isPartOf":{"@id":"https:\/\/bi.unija.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#primaryimage"},"image":{"@id":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#primaryimage"},"thumbnailUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png","datePublished":"2020-12-18T14:15:50+00:00","dateModified":"2021-01-13T14:22:47+00:00","author":{"@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10"},"breadcrumb":{"@id":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#primaryimage","url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png","contentUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/12\/39.png","width":720,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/bi.unija.com\/en\/r-and-power-bi-introduction-and-examples\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bi.unija.com\/en\/"},{"@type":"ListItem","position":2,"name":"R and Power BI \u2013 Introduction and Examples"}]},{"@type":"WebSite","@id":"https:\/\/bi.unija.com\/en\/#website","url":"https:\/\/bi.unija.com\/en\/","name":"Bi Unija","description":"Just another Bi site","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bi.unija.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10","name":"Branka Trifunovi\u0107","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","caption":"Branka Trifunovi\u0107"},"url":"https:\/\/bi.unija.com\/en\/author\/branka\/"}]}},"_links":{"self":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1855"}],"collection":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/comments?post=1855"}],"version-history":[{"count":4,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1855\/revisions"}],"predecessor-version":[{"id":1893,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1855\/revisions\/1893"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media\/1870"}],"wp:attachment":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media?parent=1855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/categories?post=1855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/tags?post=1855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}