Software + Imagination
In our previous post, we installed and set up Python to use with Power BI and used Python as a data source. Let’s look at how Python can be used to filter data inside Power Query. Let’s filter records where the number of Employees is greater than 5000. We will use the query: It should look like below. Click OK: You may get this message regarding privacy levels. Per the Power … Continue reading Using Python to Filter Data in Power Query
In our previous post, we installed and set up Python for use in Power BI. In this post, we will run a Python script and use that as a datasource in Power BI. In Power BI Desktop, select Get Data, then More: Select Python script and Connect: This will open a Python script. Paste in the code from the previous example. It should look like below. Click OK: Now click … Continue reading Using Python as a Data Source in Power BI
Python can be used in Power BI in several ways. These include: Creating visualizations using Python Using Python as a data source Scripting in Python to prepare data We will go through examples of each of these in the following posts. In this post, we will look at how to install Python in Power BI. We will then move onto how to use Python in various scenarios in Power BI. … Continue reading Installing and Setting Up Python for 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 in Power BI. In Power BI Desktop, you will see the R visualization type under Visualizations: Selecting it, we see the message to Enable script visuals. Note the warning and click Enable if you want to proceed: … Continue reading Running an R Visualization in Power BI Desktop
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
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
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
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
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
A useful feature of Power BI is setting up alerts when your data changes. Let’s look at how this works. In our example, we have a field Quantity on Hand for an item in our inventory. There are 5 items left, as we can see in this Power BI dashboard: Let’s say we want to set up an alert when the quantity drops below 3. Click on the dashboard tile … Continue reading Setting up Data Driven Alerts in Power BI