Category: Power BI

In Power BI, your data may contain a hyperlink to a webpage. For example, consider the query of Companies below that has a company name and website field: In Power BI, selecting these fields on a report will produce a text field for the hyperlink: To tell Power BI that this is a URL link, select the field, go to Modeling and change the Data Category to Web URL: These … Continue reading Converting a URL Link Field in Power BI from Text to Hyperlink to Icon

In Power BI, you can subscribe to reports or dashboards on a schedule or after data refresh. This is very useful if you would like to see a snapshot of the report without logging into Power BI. For example, if you want to see the leads generated each day, you can get this report sent automatically to your email. To do this, go to the report or dashboard. Click Subscribe … Continue reading Get Power BI Email Alerts for Reports and Dashboards Daily, Weekly or After Data Refresh

To change the font size of a Power BI report: Select a visualization and on the right go to the Format tab: To change the Column Header size, expand Column Headers. You will see Text Size: For the actual values, expand Values and find Text Size: You will see the font size change:  

Let’s look at how to hide a field in a Power BI Report. First, let’s create a report and add some data. Open Power BI Desktop, and let’s click on Enter Data. We will create 2 columns, Customer Id and Customer Name. Enter the data and click Load: We now have the 2 fields in our report: Let’s hide the Customer Id field. Right-click it and select hide: The field … Continue reading Hiding Fields in a Power BI Report and Service

When we build Power BI Reports using Power BI Desktop, we may lose the PBIX file (this doesn’t really happen, right?). In cases where this does happen, if the reports are uploaded to the Power BI Service, we can download the file directly from the Service itself. Let’s look at how this works. I have a Power BI Report called Sales Manager, with the PBIX file looking like below: I … Continue reading Download the PBIX File from Power BI Service (In Case You Lose Yours)

When using the Power BI API, we often need to use the GroupId and DataSetId. Let’s look at how to get these from the URL in the Power BI Service. To get the Workspace GroupId, click on a Workspace. In the URL, you will see a format like https://app.powerbi.com/groups/ade7c4e4-1bdd-4472-8aa5-744febb1c8e6/list/dashboards?ctid=e6cca260-b075-4884-bc8e-54b7349f1f42, with the GroupId next to /groups/: To get a DataSetId, click on a Data Set. The URL looks something like https://app.powerbi.com/groups/ade7c4e4-1bdd-4472-8aa5-744febb1c8e6/datasets/8ca80576-866c-4a1b-af6f-e6c4a0004703?ctid=e6cca260-b075-4884-bc8e-54b7349f1f42, with the … Continue reading How to Get the Workspace GroupId and DataSetId from the URL in Power BI

To install the Table Heatmap Visual by Microsoft for Power BI, first open Power BI Desktop, and under Visualizations, select Import from marketplace: Find the Table Heatmap and click Add: Click Add again: Click OK, the visualization is now imported: Now under Visualizations, you will see the new Table Heatmap icon: Select it, and add a Category and Y. We will select the Category as our Month, and the Y … Continue reading Installing and Using the Table Heatmap Visualization for Power BI

The Timeline Slicer is a Power BI visualization built by Microsoft that allows for dragging of a timeline slider to set date ranges on your reports. To install the Timeline Slicer, you can add the visual by downloading the file, or install it directly in Power BI through the Marketplace. We will go through each. Installing through File Browse to: https://app.powerbi.com/visuals?WT.mc_id=Blog_Visuals You should see the Timeline Slicer by Microsoft in the … Continue reading Installing and Using the Timeline Slicer Visual for Power BI

In Power BI, we have the ability to analyze report data in Excel. There are several ways to access this functionality. For example, select a data source and then Analyze in Excel: Alternatively, select Reports and then Analyze in Excel: Or, go to Apps and select your app: Select View Related: Select the Analyze in Excel icon: Once you select Analyze in Excel, you will see “First, you need some … Continue reading Power BI – Analyze in Excel