Ruki's Blog

The on-premises gateway is a bridge that provide a secure data transfer between on-premises data and Microsoft cloud services like Power BI. In today’s post we will discuss how to configure a proxy for On-Premises data Gateway to communicate with Power BI. So how do you determine if a proxy is blocking your Gateway connection? Run the network ports test. The results of the test will either be (Success) or (Failed). If you see failed result, it means your network environment…

Read More Read More

In this post, we will discuss how to restore a Gateway when you lost the Recovery Key, without manually recreating the Data sources for the new Gateway. I have two Power BI Gateways, one of the Gateways with most of my data sources failed to come back online after an update. I installed a new Gateway to restore the old Gateway that failed to come back online, but I have lost the Recovery Key. For now, there is no way…

Read More Read More

A quick post about how to clear Sort by Column on Power BI Desktop. On Power BI Desktop, you can select Sort by from the More options (…) on the visual and choose the column to Sort by. This automatically choose the Sort order for you: sort descending or Sort ascending. The below table is sorted by City column in descending order. You can choose to Sort by City in ascending order as well. If you change your mind not…

Read More Read More

I recently came across an issue where Total average in Power BI shows different value in Excel for the same data, which seems to be incorrect in Power BI. In today’s post, we will discuss how Power BI and Excel calculate Averages. Power BI calculate Average as an (arithmetic mean) of all the numbers in the specified column. Example; the following function “= AVERAGE(Shipping[Cost])” returns the average of the values in the column Cost in Shipping table. The function takes…

Read More Read More

A quick post today about how to use RANKX based on slicer selection in Power BI. A RANKX return the ranking of a number for each row in a table. The following DAX rank the Sales Amount for each Product and works fine without a slicer. = RANKX(ALL(Products), SUMX(RELATEDTABLE(InternetSales), [SalesAmount])) The solution below will show how to use RANKX with a slicer and get the expected result. I have two tables: Employees and Orders, related by Employee ID. I have…

Read More Read More

Power BI has many data connectors you can use to connect to your Data Source. If your Data Source is not listed from Get Data on Power BI Desktop, you can use one of the following generic data interfaces: ODBC OLE DB OData REST APIs R Scripts While working on a recent project,  I see that after adding an ODBC Data Source to Power BI Gateway using the same connection string on Power BI Desktop, the Gateway still shows ”…

Read More Read More

In this post, we will discuss the different options for On-Premises data Gateway high availability in Power BI. To refresh On-Premises Data sources on Power BI Service, you need a Gateway. You can use an on-premises data gateway cluster to avoid single points of failure and distribute load across gateways in a cluster. There are two types of high availability solutions for Power BI Gateway: Load balancing High Availability Failover High Availability Load Balancing HA: Offline gateway within a cluster…

Read More Read More