Automate Power BI Gateway installation and configuration

Automate Power BI Gateway installation and configuration

Power BI has introduced a new PowerShell cmdlets which enable automation of On-Premises Gateway installation. In this post, we will walk-through how to install and configure Power BI gateway using PowerShell cmdlets. These cmdlets require PowerShell 7 or higher. Before we begin, you will see that I have published a report using On-Premises datasource to Power BI service, but there is no Gateway configured to refresh the dataset. Let’s walk-through the steps: Install the package : Install-Module -Name DataGateway Connect…

Read More Read More

How to Audit and Fix DataFormat Error in power Query

How to Audit and Fix DataFormat Error in power Query

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…

Read More Read More

Dynamic Title for Multiple Selected values using DAX

Dynamic Title for Multiple Selected values using DAX

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…

Read More Read More

Failed to Assign External User to Power BI Workspace

Failed to Assign External User to Power BI Workspace

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…

Read More Read More

DAX-SAMEPERIODLASTYEAR (COMPARE CURRENT YEAR WITH PREVIOUS YEAR SALES)

DAX-SAMEPERIODLASTYEAR (COMPARE CURRENT YEAR WITH PREVIOUS YEAR SALES)

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…

Read More Read More

Needs Admin Approval for Azure Active Directory Power BI Content Pack

Needs Admin Approval for Azure Active Directory Power BI Content Pack

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…

Read More Read More

Integrating Python with Power BI

Integrating Python with Power BI

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…

Read More Read More

Embedding Power BI reports using App-only token “Customized”

Embedding Power BI reports using App-only token “Customized”

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…

Read More Read More

How to restore Power BI Workspace using PowerShell

How to restore Power BI Workspace using PowerShell

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…

Read More Read More

Power BI Report Performance Analyzer

Power BI Report Performance Analyzer

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…

Read More Read More

Access to the Resource is Forbidden on Power BI Desktop

Access to the Resource is Forbidden on Power BI Desktop

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…

Read More Read More

Drillthrough Cross-report in Power BI

Drillthrough Cross-report in Power BI

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…

Read More Read More