Install R Packages for Power BI R Visualizations

In Power BI, when using the R custom visualization, we may need to use an R package that is not installed. Note the list of supported packages. For example, we’re trying to use the DT library: But we get Error in Library(DT) there is no package called DT: We can use the command install.packages to try to resolve this: However, this produces this error: R script error. Installing package into … Continue reading Install R Packages for Power BI R Visualizations

Running an R Visualization from the Marketplace in Power BI

In the previous posts, we installed R for Windows and RStudio as an IDE for R. Both are configured to work with Power BI. In this post, we will run an R Visualization from the Power BI marketplace. In Power BI Desktop, under Visualizations select Import from Marketplace: Note you can see these visualizations from AppSource at https://appsource.microsoft.com/en-US/marketplace/apps?page=1&product=power-bi-visuals: Let’s install the Outlier Detection visualization from Microsoft. In Power BI Desktop, … Continue reading Running an R Visualization from the Marketplace in Power BI

Installing R Studio for Power BI

In our last post, we installed R for Power BI. Let’s now install RStudio, which is an IDE for R. First, download R Studio from¬†https://www.rstudio.com/products/rstudio/download/. We will install the free version: Select the Windows installer: This downloads the file below. Open it: Click Next: Select a path and click Next: Click Install: Click Finish: In Windows Start menu, we see the new RStudio folder with RStudio: Select it to open … Continue reading Installing R Studio for Power BI

Installing R for Power BI using CRAN Repository

To install R for Power BI on Windows, go through the following steps. First, we will download R for Windows. Go to the CRAN Repository and select Download for Windows: This will download the file below. Click to open it: Click OK: Click Next: Confirm the location and click Next: Select the files you need installed and click next. I will install on a 64-bit machine: Select customized startup or … Continue reading Installing R for Power BI using CRAN Repository

Post to Microsoft Teams based on Power BI Data-Driven Alert Using Microsoft Flow

In this post we will look at how you can perform an action based on a data-driven alert using Microsoft Flow. In our previous post, we looked at how to set up data-driven alerts. In our example, we created an alert for when our quantity on hand was less than 3 for our inventory item monitored by Power BI. To set up an action based on this alert, we can … Continue reading Post to Microsoft Teams based on Power BI Data-Driven Alert Using Microsoft Flow

Using the Power BI Horizontal Bar Chart Visualization

The Horizontal Bar Chart is a Power BI visualization from Microsoft. To install it, in Power BI Desktop, select Import from Marketplace: Click Add: Click OK: You will see the new visualization added: Let’s add some fields. We have a Revenue field and Total Amount Spent field. Let’s look at these by City: We can see the visualization is useful in comparing values:  

Using the GENERATESERIES DAX Function in Power BI

GENERATESERIES is a useful DAX function when you need to create a table with a series of values. Let’s go through how to use it. In Power BI Desktop, go to the Modeling tab and select New Table: Enter GENERATESERIES, and we can see the parameters it takes is: StartValue. This is the first row value of our new table. EndValue. This is the last row value of our new … Continue reading Using the GENERATESERIES DAX Function in Power BI

Classify Your Data with Power BI Dashboard Data Classification

Power BI has a feature that helps users understand the sensitivity of the data they are dealing with. This is referred to as Data Classification and can be useful when implementing data governance. Let’s go through how to set this up. First, Data Classification will need to be enabled by a Power BI Administrator under Tenant Settings. To do this, go to Settings and Admin portal, then select Tenant Settings, … Continue reading Classify Your Data with Power BI Dashboard Data Classification

Cross-Report Drillthrough in Power BI

Cross-report drill through is a feature in Power BI that enables users to drill through from the data of one report to another separate report. Let’s look at how this works and how to set it up. We will create 2 reports, one called¬†CrossReportDrillThroughSummary and one called¬†CrossReportDrillThroughDetail in Power BI Desktop. For each report, confirm that cross-report drillthrough is enabled: Click on Report Settings, and check Allow visuals in this … Continue reading Cross-Report Drillthrough in Power BI