Reading Time: 3 minutes One of the new features that Microsoft announced in February’s Power BI Desktop update is the Improved Python & R Script Editor. The script editor now contains the same features as the DAX editor, including IntelliSense for code completion. After spending some time with the new editor though, I made a discovery about the code completion.…
Reading Time: 4 minutes While R has been available in Power BI for a few years, Python was recently added as preview functionality to Power BI Desktop. If you have done any work with Power BI’s R Script or Python Script in Power Query, you may have noticed that many scripts appear to run slower in Power BI than if…
Reading Time: 3 minutes Microsoft recently updated the R version for Power BI Service and installed numerous additional R packages. For comparison, I posted the then-current list of packages back in July 2017. If you use R in Power BI Service, definitely see what’s available in the screenshots at the end of this post. Hopefully the Power BI documentation…
Reading Time: 2 minutes In my last post, I examined the list of R packages supported in Power BI Service. After some additional research, it turns out that I should have titled it “documented” instead of “supported”. Why is that? In addition to the 361 documented packages, there are over 200 undocumented R packages currently available to users in Power…
Reading Time: 2 minutes Microsoft maintains an official list of supported R packages available for use in the Power BI Service. There are currently 361 documented packages. While you are not as limited in your package selection when using Power BI Desktop, you have to be more careful if you are working with R in the online Service. If you use…
Reading Time: 5 minutes Using the R Script in Power BI does not exclusively have to be for advanced transformations or for connecting to sources that Power BI does not easily ingest. Sometimes, the R Script is simply faster and more convenient depending on what you want to do. To be fair, it is often slower too depending on…
Reading Time: 4 minutes Today I presented a webinar for BlueGranite called Exploring R Tools for Visual Studio. It provides a glimpse into some of the benefits of RTVS, considers when you may want to use RTVS versus RStudio (or use both), and provides a tour and demonstration of RTVS in action. This blog post of eight items I want…
Reading Time: 1 minute The BlueGranite blog recently featured a post I wrote about R Tools for Visual Studio. It’s not meant to be an in-depth exploration into RTVS. Rather, at a high level, it takes a very basic look at some reasons why a developer may choose to use RTVS either in conjunction with or in lieu of R…
Reading Time: 2 minutes One of the benefits of working on a team at BlueGranite is the collective expertise that I can tap into when needed. Whether it’s a skill that I am learning or a problem that I am stumped on, one or more of my colleagues typically has the ability to point me in the right direction. To…
Reading Time: 5 minutes Over the past few years, there has been a movement in R to create packages that bind to JavaScript libraries to make R more interactive. Notably, htmlwidgets and rCharts are two examples that come to mind. In an IDE like R Studio or a framework such as Shiny, the enhanced visualization appears and functions like it would if…