Hi, This is my code and I am trying to load the data but it is stuck on waiting for server 'servername'. Any help please?
let
// Connect to SQL Server database
Source = Sql.Database("**SERVERNAME**"),
// Access the 'archivedbookings' table
dbo_archivedbookings = Source{[Schema = "dbo", Item = "archivedbookings"]}[Data],
// Change data types for specific columns
#"Changed Type" = Table.TransformColumnTypes(
dbo_archivedbookings,
{
{"id", type text},
{"bookingId", type text},
{"pickupZoneId", type text},
{"completedByCompanyID", type text},
{"callLogId", type text},
{"vehicleId", type text},
{"driverId", type text}
}
),
// Change data types for additional columns
#"Changed Type1" = Table.TransformColumnTypes(
#"Changed Type",
{
{"viaZoneId1", type text},
{"viaZoneId2", type text},
{"viaZoneId3", type text},
{"destinationZoneId", type text},
{"companyId", type text},
{"customerId", type text}
}
),
// Keep only the 'typeOfBooking' column
#"Removed Other Columns" = Table.SelectColumns(#"Changed Type1", {"typeOfBooking"}),
// Replace null values with "BLANK" in the 'typeOfBooking' column
#"Replaced Null Values" = Table.ReplaceValue(
#"Removed Other Columns",
null,
"BLANK",
Replacer.ReplaceValue,
{"typeOfBooking"}
),
// Remove duplicate rows based on 'typeOfBooking'
#"Removed Duplicates" = Table.Distinct(#"Replaced Null Values"),
// Rename the 'typeOfBooking' column to 'Booking Type'
#"Renamed Columns" = Table.RenameColumns(
#"Removed Duplicates",
{{"typeOfBooking", "Booking Type"}}
)
in
#"Renamed Columns"
