Power BI

Signing in to Microsoft Azure and related issues, such as the relationship between an Azure subscription and Azure Active Directory.

Hello folks, The topic for today's post was borne out of the number of queries we've received from customers asking about configuring the Azure AD app proxy connector to work with existing proxies on-premises. In many organizations, network policy does not allow internal machines to access the internet directly. Therefore, going through an on-premises proxy...

We have created a tool to help you validate the networking prerequisites of the connector machine. It detects issues like closed outbound ports. You can run this tool from the connector installation Wizard: Or by following these steps: Make sure that you can open a ClickOnce software on your server and make connectorsnam1cus.blob.core.windows.net a trusted site. Open...

Covers how to use Azure AD Application Proxy to provide secure remote access to your on-premises apps.

Note: This post is written as of December 2014 and represents functionality at this time. Shameless Plug for Spatula City I fear those who have never seen UHF and its famous Spatula City commercial will worry about my mental health. But compared to Adventure Works or Contoso, I feel that

Update : Power BI Analysis Services Connector is now GA. You can download the latest version of the Connector clicking the download icon on the Power BI service. If you already installed a preview version, you can upgrade to the latest version without...

I am getting a 'Register gateway failed' when entering Windows credentials in the Gateway setup. I have checked and the service is running, under my Windows username. What is it trying to register with - is it an online address, and could it therefore be a proxy/firewall issue? We had to add a proxy...

Last couple of weeks, I tried to install the Power BI Analysis Services Connector, and ran into a few issues (and found some solutions). I thought it'd be good to share them, in case anyone runs into the same issues. So here's my story of installing Power BI Analysis Services connector - translated to a…

Hi guys,   I am trying to uninstall the personal gateway from my computer. However the process hangs with an open empty window "Power BI Personal Gateway Uninstallation".   Has anyone met the same problem and how can I solve it?   Thanks Tsanka

I've installed the Power BI Personal Gateway (version 1.5.5675.2) onto my Windows 7 machine but cannot successfully sign in to Power BI. The error I receive is:   Failed to login to Power BI The remote server returned an error: (407) Proxy Authentication Required.   Note that our proxy is on port 80...

I need to know what the address for my proxy server is so I can configure another program to also use it. If I go into IE, Internet Properties, LAN Settings, then all I see is an automatic configu...

I’ve blogged a few times now about how to monitor Power BI query execution times, most recently here, and while using functions like DateTime.FixedLocalNow() is all very well I’ve never been happy …

Do you want to connect to a Power BI Desktop Model from Excel or SSMS? Do you have Power BI Performance issues? Then this article is for you.

Today, we're going to talk about how to use Slicers to choose which measure you want to display in your Table or Chart.  This is probably on...

Today, we're going to expand on our previous post .  In the previous post, we built a simple data model using a sample data set.  However, t...

In this post you see how SSRS 2016 and Power BI integration works, how to pin your SSRS visuals to Power BI and how deal with common errors and issues.

Following on from my previous post, let’s now look at how you can add derived columns to a table expression. Let’s start with a simple query that returns every column in DimDate: evaluate( DimDate …

This article introduces Power BI Desktop templates, which allows you to reuse your reports and visuals with different parameters and data.

Note: This list is no longer being updated as of July 15, 2016. It is still available simply for historical reference. The Power BI team is constantly adding updates to the Power BI service, deskto…

Today, we're going to talk about how to add negative rows to your transaction table using Power Query.  Many IT installations have some sort...

One of the key powers of Power BI is the ability to bring data from different sources into a single model and then join them together by creating relationships among tables to perform analysis and …

We have a large dataset of unstructured data (Azure Blob) and have started noticing that refreshing our model gets quite slow after a few thousand records are being loaded.   Our current query structure is: #"Load Data" Loads data from the Azure Blob, ~1000 files Parses the files into a ta...

If...Then...Else in a Custom Column We have all used an "if...then...else" statement, when adding a custom column in Power BI query (using Excel Power Query, or Power BI Get Data). Here is a quick example from our book, Chapter 20 "Power Query to the Rescue", Scenario #3 – Adding Custom Columns to...

Microsoft’s Power BI team has put together a tutorial on a proposed approach for visualizing the output of an Azure Machine Learning model inside Power BI. A blog post invites users to “imagine if you could have Power BI regularly bring in the latest output of your fraud model or the sentiment for recent Tweets...