Data gateway setup in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows data sources connected through data gateways in Power BI, their connection status, and the gateway used.

Cell	Value
A1	Data Source
B1	Status
C1	Gateway Name
A2	SQL Server
B2	Connected
C2	Gateway01
A3	Excel File
B3	Disconnected
C3	Gateway01
A4	SharePoint
B4	Connected
C4	Gateway02

Formula Trace

IF(B2="Connected", "Data Ready", "Check Gateway")

Step 1: B2="Connected"

Step 2: IF(TRUE, "Data Ready", "Check Gateway")

Cell Reference Map

   A           B           C
1 Data Source  Status      Gateway Name
2 SQL Server  Connected   Gateway01
3 Excel File  Disconnected Gateway01
4 SharePoint  Connected   Gateway02

The formula references cell B2 to check the connection status of the SQL Server data source.

Result

   A           B           C           D
1 Data Source  Status      Gateway Name  Connection Check
2 SQL Server  Connected   Gateway01    Data Ready
3 Excel File  Disconnected Gateway01   
4 SharePoint  Connected   Gateway02    

The formula in column D checks if the data source in row 2 is connected. It shows 'Data Ready' because B2 is 'Connected'.

Sheet Trace Quiz - 3 Questions

What does the formula check in cell B2?

A If the data source is connected

B If the gateway name is Gateway01

C If the data source is SQL Server

D If the status is Disconnected

Key Result

IF(condition, value_if_true, value_if_false) checks a condition and returns one of two values accordingly.