Just like any other language, Power Query has its own different types of errors, one of them is DataFormat Error. Dataformat errors in Power Query are mostly data type errors and do not prevent you from loading data to Power BI, instead the cells will be loaded as blank. The screenshot below shows 3 errors for 78 records when the data is loaded to Power BI. To audit the error or get more details, do the following: Click on View…
Today’s post is about creating a dynamic title for multiple slicer selection for Power BI report. Dynamic title means your title and visual changes based on the filter context. I was working on a project last week and needed to create a dynamic title for a report based on multiple slicer selection. I did some research and came across a good video from Guy in the cube that helps me in achieving my goal. Let’s start by creating a simple…
As Power BI Administrator, you can view all Workspaces in your Tenant via Admin Portal, but it does not automatically allow you to access contents in a Workspace you are not a member of. If you try to assign an external B2B user to a Workspace in Power BI via Admin portal and you are not a member of that Workspace, you will receive a “Failed to assign” error message. As an Administrator, I tried to assign an external B2B…
Today’s post is about how you compare Current year and Previous year sales using DAX- SAMEPERIODLASTYEAR function in Power BI. SAMEPERIODLASTYEAR Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context. 1. We will start by creating a Date table using the “New Table” option under Modeling. CALENDAR(<start_date>, <end_date>) Set the start date to go back one year before the current date Set…
A quick post today. I got this question from someone who needed to access Azure AD Content Pack in Power BI Service but received “Needs Admin Approval” error message. The Power BI content pack for Azure AD gives you insight about all the activities within your environment. To access the content pack, you need an Azure AD premium license. Users in the Global Admin, Security Admin, Security Reader or Report Reader roles have access to the data at Tenant level. If…
While working on a project about integrating Python with Power BI recently, I decided to write a blog post about it. Python is a high level, object-oriented programming language that is used for Data science, Web development and Scripting. With Python you can perform quick data import, data transformation and data visualizations in Power BI. There are three ways to integrate Python with Power BI Create Python visualizations using Python script editor Run Python script to import data as datasource…
In this post, you will learn how to embed Power BI reports into your web application using Service principal and share with your customers who do not have Power BI account. Embedding report using Service Principal means you don’t need a master account that has a username and password to authenticate into your application. Service principal uses an application ID and an application secret to authenticate the application (App-only token). The following information is required to embed your report into…
A week ago, I mistakenly deleted a Power BI workspace that has most of my reports, dashboards and datasets. Today, I am pleased to share with you how it was restored. For working with workspaces, dashboards, reports, datasets and data sources, you can use the more specialized PowerShell cmdlets Get-PowerBIWorkspace, Get-PowerBIReport, Get-PowerBIDataset. All management cmdlets have an optional parameter called Scope. This parameter can take one of two possible values: Individual and Organization. This example only work with -Scope Organization and administrator right…
Power BI has added the ability to analyse report performance on Power BI Desktop. This means if your reports are running slow , you can now use Performance analyzer on Power BI Desktop to identify the culprit and find out the reason for the impact. From View, click Performance Analyzer to enable the option Click on Start recording to begin recording the performance When you interact with your report, like refreshing the visuals, filtering the reports etc. Performance Analyzer logs…
Just a quick post today to share a fix for an error that I have come across multiple times on Power BI Desktop and Excel Power Query when refreshing reports. “Access to the Resource is Forbidden” When receiving this message on Power BI Desktop for a SharePoint online data source or other data sources, do the following: Update the Power BI desktop to the latest version Ensure that the account you are using to authenticate on Power BI Desktop…
Someone recently asked me: “If it’s possible to drillthrough from one report to another in the same Power BI workspace” Like hopping from one report to another related report housed in the same workspace. Voila! the feature is now available with the April 2019 Power BI Desktop Update. Here is how: Update your Power BI Desktop to April 2019 Version Enable the cross-report drillthrough feature for both source and target reports on Power BI Desktop. From File > Options and…
A while ago, I came across an error message similar to the one I will be discussing in this post. You will learn how to create R Visuals in Power BI Desktop using the R Script visual. Before creating the visual you have to ensure that the Detected R home directories on Power BI Desktop matches your local R installation path and version. For this example, I have R-3.4.3 installed, so my Detected R home directories from File -> Options…