Using Tooltips to Show an Image on Hovering Over a Power BI Record

In this post, we will look at how to set up Power BI tooltips so when a user hovers over a record, it displays an image. Let’s follow on from a previous post where we showed how to display images from a URL in Power BI. We will now display only the City name in the report, and when the user hovers over the name, the tooltip will display the … Continue reading Using Tooltips to Show an Image on Hovering Over a Power BI Record

Using Python to Filter Data in Power Query

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

Installing and Setting Up Python for 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

Running an R Visualization in Power BI Desktop

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

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