A quick post today about Last refresh Data/Time on a Power BI Service. The Last Refresh Date/Time alerts users how new the data is for the report. You can visualize the Last refresh Date/Time with a card that shows the date and time that the data for the report was last updated. On Power BI Desktop and Power BI Report Server, you can use DateTime.LocalNow() to get the Last refresh Date/Time for a report. When you publish the same report…
Power BI recently announced an amazing feature called Power BI Desktop Developer Mode. In today’s post, we will discuss how you can use the Power BI Desktop Developer Mode to track version history and compare the differences. Here is what you can do with this feature: Collaboration: Source control allows multiple team members to work simultaneously on the same Power BI project without the fear of overwriting or losing changes. It enables collaboration by providing a centralized repository where everyone…
If your data is stored on an internal server, then you need an On-Premises Gateway for data refresh on Power BI Service. In today’s post, we will discuss how to determine the correct sizing for your On-Premises Data Gateway machine. Determining the correct sizing for your Gateway machine can depend on the following : For Import mode: Cache data workloads require enough CPU and Memory. For Live Connection and DirectQuery: Live Connection and DirectQuery workloads require sufficient CPU. Power BI…
OneDrive for Applications = OneLake for Data. OneLake is a single place for all your analytics data. Every tenant has exactly one OneLake. Fabric stores Lakehouses, Warehouses, and other items in OneLake. Microsoft Fabric Lakehouse is a platform designed to store, manage, and analyze structured and unstructured data in a single location. To create a Lakehouse with OneLake , you first need to enable Microsoft Fabric in your Tenant, and the Fabric trial license if you don’t have Fabric Capacity….
In today’s post, we will discuss how to get metadata for a requested list of Workspaces using the Power BI Scanner API. The result shows Data sources and connection details for each Workspace, Data sources used by each Dataset, and Reports connected to each Dataset. For the Datasets, you can also extract metadata like tables, columns, measures, DAX expressions, mashup queries, and so on. To accomplish this, we will use 4 Scanner APIs: The user must be an administrator to…
A quick post today about the different types of groups used in Power BI service. Microsoft Groups are a collection of users that drive teamwork across Microsoft 365. With Microsoft 365 Groups, you can give a group of users access to a collection of shared resources like Power BI. When sharing Power BI content to a large audience, a more efficient way is to use Groups. It can be time-consuming to share to individual users. Below are Microsoft groups used…
Manage gateway installers On Power BI service Gateway management or Power platform Admin center, a Global admin or a Power BI service admin can use Manage gateway installers to manage who can install an on-premises data gateway in a tenant. This feature does not apply to personal gateways. A Power BI idea for approval process before gateway becomes active has been completed. However, to restrict or prevent users from installing personal gateways in a Power BI tenant, you need to…
In this post, we will discuss how to convert Hours into Minutes and add it to the existing Minutes to get a whole number. I tried two different methods and got the same result, so I decided to share it with you. Let’s walkthrough the steps: I have a simple table with a Ticket and Time columns. I need to convert the Hours to Minutes and add it to the existing Minutes in the Time column to get a whole…
A quick post today about how to calculate Average for a column with text data type in Power BI. In Power BI, you can only count the the number of rows in a column that has a text data type under summarization, other summarizations are not available for a text data type. If you attempt to use an Average function in a measure for a text column, you will get an error message like the one below: To calculate the…
I was working on a project last week to filter a Stacked bar chart for multiple selections on a slicer with AND condition, so I decided to write a blog post about it. Let’s start by creating a simple Stacked bar chart in Power BI for all Products: The issue : By default, when you select multiple items on a slicer to filter the result in a Stacked bar chart, it displays the result even if one condition is met,…
In today’s post, we will discuss how to automate exporting Power BI Workspaces, Datasets, Reports and Dashboards using PowerShell. Step one: To use PowerShell cmdlets for managing and interacting with Power BI, you first need to install the module: MicrosoftPowerBIMgmt Install-Module -Name MicrosoftPowerBIMgmt Step two: Sign in to Power BI using below command, a prompt will pop up to authenticate to Power BI. For this example, I am authenticating as Power BI Admin. Connect-PowerBIServiceAccount Note: You can also authenticate using…
There are many ways to Share or Collaborate on Power BI contents. In today’s post, we will discuss best practice for three main ways: Share– Share reports or dashboards from your “My Workspace or another Workspace”. Workspace – Collaborate on contents within a Workspace. Apps –Bundle reports and dashboards in a Workspace into an App and distribute to users. BEST PRACTICE Use Share reports or dashboards from your “My Workspace or another Workspaces” when you want to allow read- only access to…