From time to time BitaBIZ will update our API. 

In some cases this will affect your BitaBIZ integration to PowerBI. 

If you run the querries below this will fix the problem.

Employees

let

Source = Csv.Document(Web.Contents("https://registrations.api.bitabiz.com/pbi//employees"),[Delimiter=",", Columns=37, Encoding=65001, QuoteStyle=QuoteStyle.None]),

#"Use First Row as Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

#"Change Type" = Table.TransformColumnTypes(#"Use First Row as Headers",{{"guid", type text}, {"name", type text}, {"fullname", type text}, {"department", type text}, {"jobTitle", type text}, {"employeeId", type text}, {"employeePayrollId", type text}, {"country.name", type text}, {"country.region", type text}, {"groupCompany", type text}, {"personalInfo.email", type text}, {"personalInfo.birthdate", type datetime}, {"personalInfo.mobile", type number}, {"employment.start", type datetime}, {"employment.end", type text}, {"lastLogin", type datetime}, {"active", type logical}, {"salaryAgreement.id", Int64.Type}, {"salaryAgreement.name", type text}, {"salaryAgreement.workingDays", Int64.Type}, {"salaryAgreement.hoursPerWeek", Int64.Type}, {"salaryAgreement.vacationDays", Int64.Type}, {"salaryAgreement.otherVacationDays", Int64.Type}, {"salaryAgreement.weekDaysCsv.weekDay1English", type text}, {"salaryAgreement.weekDaysCsv.weekDay1", Int64.Type}, {"salaryAgreement.weekDaysCsv.weekDay2English", type text}, {"salaryAgreement.weekDaysCsv.weekDay2", Int64.Type}, {"salaryAgreement.weekDaysCsv.weekDay3English", type text}, {"salaryAgreement.weekDaysCsv.weekDay3", Int64.Type}, {"salaryAgreement.weekDaysCsv.weekDay4English", type text}, {"salaryAgreement.weekDaysCsv.weekDay4", Int64.Type}, {"salaryAgreement.weekDaysCsv.weekDay5English", type text}, {"salaryAgreement.weekDaysCsv.weekDay5", Int64.Type}, {"salaryAgreement.weekDaysCsv.weekDay6English", type text}, {"salaryAgreement.weekDaysCsv.weekDay6", Int64.Type}, {"salaryAgreement.weekDaysCsv.weekDay7English", type text}, {"salaryAgreement.weekDaysCsv.weekDay7", Int64.Type}})

in

#"Change Type"

Employee history

let

Source = Csv.Document(Web.Contents("https://registrations.api.bitabiz.com/pbi//employees/history"),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),

#"Use First Row as Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

#"Change Type" = Table.TransformColumnTypes(#"Use First Row as Headers",{{"guid", type text}, {"name", type text}, {"history.year", Int64.Type}, {"history.vacationEarned", type number}, {"history.vacationAdjustment", type number}, {"history.otherVacationEarned", Int64.Type}, {"history.otherVacationAdjustment", type number}})

in

#"Change Type"

Registrations

let

Source = Csv.Document(Web.Contents("https://registrations.api.bitabiz.com/pbi//registrations?from=last24months"),[Delimiter=",", Columns=22, Encoding=65001, QuoteStyle=QuoteStyle.None]),

#"Change Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", type text}, {"Column18", type text}, {"Column19", type text}, {"Column20", type text}, {"Column21", type text}, {"Column22", type text}})

in

#"Change Type"

Did this answer your question?