Hi @baana2005, unfortunately nothing comes to my mind, if you share your PBIX file i can review it directly
1 Like
Dear @osmanburcu ,
Here in the link to the PBIX file,
Dear @osmanburcu ,
I have shared the file you requested, kindly assist, Thank you.
@baana2005 Dear, i reviewed your file but there is no Kobo connection, all XLSX file not JSON. I believe you shared and edited format with me
1 Like
Dear @osmanburcu ,
My bad, you know previously before you started aissting me I was using direct connection Kobo to Power BI which is given me problem and you suggested i should connect Kobo to Excel then connect Excel to Power BI, while I am attaching the file I forgot to send you the exact files, kindly find the link to the folder of all file related to the Power BI
I believe you shared the wrong file again but it is fine. Does your dashboard work without any problem in excel format? If yes I would suggest a method to you that instead of using API v1, you can use the API v2 and instead of downloading your data in excel format and connect it to Power BI. You can directly import that excel data into Power BI and you can set up a automatic update? By this method you don’t need to download the data in three-four link. Please check the video below, if you have any more question, just let me know
1 Like
Dear @osmanburcu ,
The link I share with you have all the files, the excel files from the main file “Data” and the other linked files also Power BI is there too, see screenshot
also direct excel data file
Steps which i follow to link the file are
- Connected Excel to Kobo Server using the limiting the number of submissions (like your guidance in the previous message trail)
- Connected Excel to Power BI which is easy way to refresh it without taking everlasting, the reason I didn’t connect Kobo directly to Power BI is because I duplicate the main data 49 times which if is connected directly to kobo during the refresh it will query each duplicate and will take longer time, see screenshot
Previously the steps I mention is working perfectly, anytime I will just open the excel file which is connected to kobo and refresh the limited submission files and save it then open power bi and refresh very fast but it’s stopped refreshing the excel from kobo, I will appreciate your assistance as usual. Thank you
Dear @osmanburcu ,
Kindly assist,
Dear @hakan_cetinkaya,
If you have the chance can you kindly loot at the issue i raised which solution has not been found for me yet,
I hope this message finds you well. I am writing to report an issue I’ve encountered with exporting data directly to Excel from KoboToolbox. Specifically, some columns are missing in the exported file, and despite trying different solutions, the problem persists.
Project Details:
• Project Name: Harmonized Protection Monitoring Tool Household Assessment (HHA)
• Project Link: HHA Project on KoboToolbox [KoboToolbox]
• Username: npsne
Export Details:
• Link to Export:
• Data Export Part 1 [https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=0&limit=20000]
• Data Export Part 2 [https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=20001]
Issue:
An example of a missing column in the exported data is:
section_2_general_protection/what_are_the_reasons_for_people_in_your_location_to_feel_unsafe/Risk_of_recruitment_by_NSAGs
This issue has been ongoing for almost two months, and as a result, I am unable to refresh the Power BI dashboard linked to the Excel file exported from Kobo.
Your prompt assistance in resolving this matter would be greatly appreciated.
Thank you for your attention to this issue.
@baana2005, pinging @osmanburcu (for your support again) who is our KoboToolbox ambassador (expert) with Power BI.
Dear @baana2005, your problem is not from the Kobo side but Power BI side, Probably your issue smilar to this Error message "The column _notes not found" . As you are importing as JSON format, your total number of column is static in the Power BI, So go to Power query editor, then open the advance editor and check the source line and find the “column= {some number}”, just increase this number lets say 50 and see if your problem is solved. If solved you can find the exact number of columns and change it. If this doesn’t solve your problem, let me know
1 Like
Dear @osmanburcu ,
Well I tried to check the “column={some number}” but is not there, below is the advance editor code,
let
Source = Json.Document(Web.Contents(“https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=0&limit=20000”, [Headers=[Authorization=“Token f6c669ffb4d4dfd53036951d2ad9ad420134263b”]])),
results = Source[results],
#“Converted to Table” = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.List),
#“Expanded Column1” = Table.ExpandRecordColumn(#“Converted to Table”, “Column1”, {“id", “formhub/uuid”, “start”, “end”, “today”, “deviceid”, “group_general_information/effective_date”, “group_general_information/country”, “group_general_information/state”, “group_general_information/LGA”, “group_general_information/WARD”, “group_general_information/location”, “group_general_information/GPS”, “group_general_information/organisation_code”, “group_general_information/organisation_11”, “group_introduction/Code_of_person”, “group_introduction/respondent_is_major”, “group_introduction/consent”, “group_introduction/language”, “section_2_general_protection/respondent_sex”, “section_2_general_protection/respondent_age”, “section_2_general_protection/C1”, “section_2_general_protection/hoh”, “section_2_general_protection/no_hoh”, “section_2_general_protection/Age”, “section_2_general_protection/C2”, “section_2_general_protection/headed_hoh_male_above_18_no”, “section_2_general_protection/Q1_header/Number”, “section_2_general_protection/Q1_header/Disaggregation_of_members_of_your_HH_that_fit_into_age_and_sex_brackets”, “section_2_general_protection/Q1_header/Less_than_5_Years_Female”, “section_2_general_protection/Q1_header/Between_18-25_Years_Female”, “section_2_general_protection/Q1_header/Less_than_5_Years_Male”, “section_2_general_protection/Q1_header/age_group_sum”, “section_2_general_protection/Q1_header/age_group_sum_children_below_17”, “section_2_general_protection/family_members_loc”, “section_2_general_protection/sep_family_members_loc”, “section_2_general_protection/una_family_members_loc”, “section_2_general_protection/are_all_school_aged_children_going_to_school”, “section_2_general_protection/status_hh”, “section_2_general_protection/dis_country”, “section_2_general_protection/dis_state”, “section_2_general_protection/dis_lga”, “section_2_general_protection/dis_ward”, “section_2_general_protection/location_hh”, “section_2_general_protection/hh_current_settlement_type”, “section_2_general_protection/current_shelter_type_1”, “section_2_general_protection/area_origin_country”, “section_2_general_protection/area_origin_state”, “section_2_general_protection/area_origin_lga”, “section_2_general_protection/area_origin_ward”, “section_2_general_protection/location_displaced”, “section_2_general_protection/when_last_displaced”, “section_2_general_protection/How_many_times_have_you_been_displaced_in_the_last_5_years”, “section_2_general_protection/what_was_the_cause_of_your_displacement”, “section_2_general_protection/red_flag_1_system”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_ret”, “section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of_displacement_why_idp_ret”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_women_and_girls_in_the_last_3_months”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_men_and_boys_in_the_last_3_months”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_people_living_with_disabilities_in_the_last_3_months”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_older_persons_in_the_last_3_months”, “section_2_general_protection/Can_people_move_around_freely_within_your_current_location”, “section_2_general_protection/Can_people_move_freely_out_of_your_current_location”, “section_2_general_protection/do_members_of_your_HH_possess_civil_and_legal_documentation”, “section_2_general_protection/Do_your_HH_members_possess_documents_on_housing_land_and_property”, “section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_or_legal_documentation”, “section_2_general_protection/does_any_of_your_HH_members_face_any_problems_because_of_the_lack_of_personal_documentation”, “section_2_general_protection/Has_any_member_of_your_household_experienced_any_protection_incident_rights_violation_in_your_current_location_or_location_of_origin”, “section_2_general_protection/Are_there_different_population_groups_present_in_your_location”, “section_2_general_protection/How_would_you_describe_the_relationship_between_displaced_populations_and_HCs_in_your_location”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_informed_about_the_different_services_that_are_provided_by_humanitarian_organizations_for_the_population_in_need_in_your_location”, “section_3_accountability_to_AAP_community_engagement/How_well_does_your_HH_feel_informed_about_the_different_services_that_are_provided_by_humanitarian_organizations_for_the_population_in_need_in_your_location”, “section_3_accountability_to_AAP_community_engagement/Food_assistance”, “section_3_accountability_to_AAP_community_engagement/Nutrition_assistance”, “section_3_accountability_to_AAP_community_engagement/Shelter_assistance”, “section_3_accountability_to_AAP_community_engagement/NFI_assistance”, “section_3_accountability_to_AAP_community_engagement/WASH_assistance”, “section_3_accountability_to_AAP_community_engagement/Education_assistance”, “section_3_accountability_to_AAP_community_engagement/Health_assistance”, “section_3_accountability_to_AAP_community_engagement/Services_for_GBV_survivors”, “section_3_accountability_to_AAP_community_engagement/Services_for_children_in_need_of_support”, “section_3_accountability_to_AAP_community_engagement/Legal_services”, “section_3_accountability_to_AAP_community_engagement/Mental_Health_Psychosocial_support_services”, “section_3_accountability_to_AAP_community_engagement/Livelihood_services”, “section_3_accountability_to_AAP_community_engagement/What_kind_of_information_does_your_HH_want_to_receive_from_humanitarian_organizations_on_aid_or_services”, “section_3_accountability_to_AAP_community_engagement/What_would_be_your_HHs_preferred_channel_to_receive_information_about_available_aid_or_services_of_humanitarian_organizations”, “section_3_accountability_to_AAP_community_engagement/Community_leaders”, “section_3_accountability_to_AAP_community_engagement/Does_your_HH_feel_that_it_is_consulted_on_the_kind_of_aid_or_services_that_are_offered_by_humanitarian_organizations_in_your_location”, “section_3_accountability_to_AAP_community_engagement/Do_you_feel_the_kind_of_services_offered_by_humanitarian_organizations_are_responding_to_your_HHs_problems_and_meeting_the_needs_your_HH_has”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_aware_of_ways_to_complain_about_the_delivery_of_humanitarian_services_and_to_provide_feedback_for_the_improvement_of_humanitarian_services”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and_provide_feedback_to_humanitarian_organizations_are_you_aware_of”, “section_3_accountability_to_AAP_community_engagement/Has_your_HH_ever_used_any_of_these_modalities_to_provide_feedback_or_to_complain_to_aid_organizations_on_the_assistance_received”, “section_3_accountability_to_AAP_community_engagement/did_you_receive_any_feedback_assistance”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_people_in_your_community_face_when_wanting_to_utilize_any_of_the_mechanisms_to_provide_feedback_and_complain”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_that_you_are_NOT_supposed_to_pay_whether_by_cash_or_by_offering_sex_to_receive_humanitarian_aid”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_an_aid_worker_with_a_child__is_unacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_relationship_between_aid_workers_and_adults_is_unacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/An_exchange_of_good_services_for_sex_between_an_aid_worker_and_a_beneficiary_is_unacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_aid_workers_with_prostitutes_is_inacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_of_a_mechanism_to_raise_complaints_in_case_of_incidents_related_to_sexual_misconduct_from_aid_workers”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanisms_are_available_in_your_location_site”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Among_those_reporting_mechanisms_which_one_would_you_prefer”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/would_your_hh_feel_confident_complaint”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/report_sexual_misconduct_by_air_worker”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Basic_material_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Medical_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Psycho_social_support”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Legal_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Safe_shelter”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Reintegration_in_the_community”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/DNA_paternity_identification_for_children_born_from_experience_of_sexual_misconduct_of_aid_workers”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitarian_organizations_do_to_address_the_problem_of_sexual_misconduct_of_aid_workers”, “Section_5_Priority_needs_and_access_to_services/Priority_No_1”, “Section_5_Priority_needs_and_access_to_services/condition_1”, “Section_5_Priority_needs_and_access_to_services/NFIs1”, “Section_5_Priority_needs_and_access_to_services/Priority_No_2”, “Section_5_Priority_needs_and_access_to_services/condition_2”, “Section_5_Priority_needs_and_access_to_services/Food2”, “Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “Section_5_Priority_needs_and_access_to_services/condition_3”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training3”, “Section_6_Referrals/Does_the_HH_require_a_referral_to_service_providers”, “Section_6_Referrals/From_the_information_you_have_shared_I_can_see_that_y”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major”, “Section_6_Referrals/Comments_to_be_filled_out_by_the_protection_monitor_major”, “Section_6_Referrals/referral_details_nfis/referral_repeat_nfis”, “version”, “meta/instanceID”, “xform_id_string", “uuid", “attachments", “status", “geolocation", “submission_time", “tags", “notes", “validation_status", “submitted_by", “section_2_general_protection/Q1_header/Between_26-59_Years_Female”, “section_2_general_protection/headed_hoh_male_child_above_60_no”, “section_2_general_protection/Q1_header/Between_5-12_Years_Female”, “section_2_general_protection/headed_hoh_female_above_18”, “section_2_general_protection/Q1_header/Between_13-17_Years_Female”, “section_2_general_protection/Q1_header/Between_5-12_Years_Male”, “section_2_general_protection/Q1_header/Between_13-17_Years_Male”, “section_2_general_protection/Are_women_among_those_HH_members_who_possess_civil_and_legal_documentation”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members_of_your_HH_possess”, “Section_6_Referrals/Last_name”, “Section_6_Referrals/FIrst_name”, “section_2_general_protection/Q1_header/Between_18-25_Years_Male”, “section_2_general_protection/what_are_the_reasons_for_children_not_going_to_school”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_being_stopped”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_movement_being_restricted”, “Section_6_Referrals/phone_num”, “section_2_general_protection/Q1_header/Between_26-59_Years_Male”, “Section_5_Priority_needs_and_access_to_services/NFIs3”, "Section_5_Priority_needs_and_access_to_services/Priority_No_1”, "Section_5_Priority_needs_and_access_to_services/Priority_No_2”, "Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “section_2_general_protection/child_at_rist”, “section_2_general_protection/elderly_at_rist”, “section_2_general_protection/none_of_the_HH_members_is_vulnerable”, “Section_5_Priority_needs_and_access_to_services/Food1”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training2”, “Section_5_Priority_needs_and_access_to_services/Shelter1”, “Section_5_Priority_needs_and_access_to_services/NFIs2”, “section_2_general_protection/intend_move_current_location_idp_ret”, “section_2_general_protection/intend_move_preferred_destination_idp_ret”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move”, “section_2_general_protection/when_do_you_want_to_move_to_country”, “section_2_general_protection/when_do_you_want_to_move_to_state”, “section_2_general_protection/when_do_you_want_to_move_to_lga”, “section_2_general_protection/when_do_you_want_to_move_to_ward”, “section_2_general_protection/location_move_to”, “section_2_general_protection/intend_move_current_access_info”, “section_2_general_protection/info_hh_make_decision_preferred_location”, “section_2_general_protection/requirement_move_preferred_location”, “section_2_general_protection/sources_info_location_intended”, “section_2_general_protection/current_location_hh”, “section_2_general_protection/media_sources_hh”, “section_2_general_protection/Fredom_group_001/freedom_movement_questions_001”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_impacted_people_in_your_location”, “section_2_general_protection/Do_people_in_your_location_report_these_restrictions_on_their_freedom_of_movement”, “section_2_general_protection/Who_do_they_generally_report_these_restrictions_to”, “section_2_general_protection/when_people_in_your_community_reported_any_of_these_restrictions_on_their_freedom_of_movement_was_a_solution_found_to_improve_their_freedom_of_movement”, “section_3_accountability_to_AAP_community_engagement/Village_elders”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_people_in_your_community_face_when_wanting_to_utilize_any_of_the_mechanisms_to_provide_feedback_and_complain_other”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanisms_are_available_in_your_location_site_other_001”, “Section_5_Priority_needs_and_access_to_services/WASH3”, “Section_5_Priority_needs_and_access_to_services/WASH2”, “Section_5_Priority_needs_and_access_to_services/Food3”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and_provide_feedback_to_humanitarian_organizations_are_you_aware_of_other”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training1”, “section_2_general_protection/women_at_rist”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_refugee”, “section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of_displacement_why_idp_refugee”, “section_3_accountability_to_AAP_community_engagement/Religious_leaders”, “Section_5_Priority_needs_and_access_to_services/Shelter3”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_access_humanitarian_services_or_commodities_for_people_in_need_in_your_location_q1”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_cannot_access_needed_services_or_commodities_what_do_they_do_q1”, “Section_6_Referrals/referral_details_food/referral_repeat_food”, “Section_6_Referrals/referral_details_livelihood_vocational_training/referral_repeat_livelihood_vocational_training”, “Section_6_Referrals/referral_details_shelter/referral_repeat_shelter”, “Section_5_Priority_needs_and_access_to_services/Shelter2”, “Section_6_Referrals/dob”, “Section_6_Referrals/comments”, “section_2_general_protection/requirement_move_preferred_location_other_001”, “section_2_general_protection/what_are_the_reasons_for_people_in_your_location_to_feel_unsafe”, “section_2_general_protection/Attacks_against_the_population”, “section_2_general_protection/Risk_of_abduction_and_demands_for_ransom”, “section_2_general_protection/In_which_of_the_following_locations_do_all_community_members_men_boys_women_girls_often_not_feel_safe”, “section_2_general_protection/In_the_fields_when_fetching_firewood_water_scrap_metal”, “section_2_general_protection/In_the_fields_when_doing_farming”, “section_2_general_protection/Does_your_community_have_strategies_to_deal_with_the_lack_of_safety_for_community_members”, “section_2_general_protection/when_did_the_HH_member_experience_the_protection_incident”, “section_2_general_protection/type_of_incid_tookplace/type_of_incid_tookplace_questions”, “section_2_general_protection/whom_do_people_in_your_community_report_protection_incidents_to”, “section_2_general_protection/did_the_HH_members_affected_by_the_protection_incident_receive_any_relevant_support_or_services”, “Section_5_Priority_needs_and_access_to_services/Education3”, “section_2_general_protection/child_at_rist_school”, “section_2_general_protection/separated/Number_sep”, “section_2_general_protection/separated/Dissaggregation_of_children_within_your_HH_separated”, “section_2_general_protection/separated/Female5”, “section_2_general_protection/separated/Female5to12”, “section_2_general_protection/separated/Male5to12”, “section_2_general_protection/separated/number_separated_sum”, “section_2_general_protection/serious_med_cond”, “section_2_general_protection/are_women_among_those_possessing_HLP_documentation”, “section_2_general_protection/what_type_of_HLP_documents_do_your_HH_members_possess”, “section_2_general_protection/headed_hoh_male_child_above_60”, “section_2_general_protection/headed_hoh_male_above_18”, “section_2_general_protection/Q1_header/Above_60_Years_Female”, “section_2_general_protection/Q1_header/Above_60_Years_Male”, “section_2_general_protection/disabilities”, “section_2_general_protection/headed_hoh_female_child_above_60”, “section_2_general_protection/current_shelter_type_2”, “Section_5_Priority_needs_and_access_to_services/Education1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property3”, “Section_5_Priority_needs_and_access_to_services/Health3”, “Section_5_Priority_needs_and_access_to_services/Health2”, “Section_5_Priority_needs_and_access_to_services/Education2”, “section_2_general_protection/unaccompanied/Number_una”, “section_2_general_protection/unaccompanied/Dissaggregation_of_children_within_your_HH_unaccompanied”, “section_2_general_protection/unaccompanied/Male5_una”, “section_2_general_protection/unaccompanied/number_unaccompanied_sum”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitarian_organizations_do_to_address_the_problem_of_sexual_misconduct_of_aid_workers_other”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_access_humanitarian_services_or_commodities_for_people_in_need_in_your_location_other_q1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property2”, “section_2_general_protection/In_some_blocks_of_the_camp_community”, “section_2_general_protection/Proximity”, “section_2_general_protection/Presence_of__NSAGs”, “section_2_general_protection/Criminal_activities_in_the_area”, “section_2_general_protection/In_some_streets_of_the_camp_community”, “section_2_general_protection/Within_their_house_tent”, “section_2_general_protection/what_are_these_strategies”, “section_2_general_protection/Fredom_group/freedom_movement_questions”, “Section_5_Priority_needs_and_access_to_services/Health1”, “section_2_general_protection/hh_current_settlement_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women2”, “Section_5_Priority_needs_and_access_to_services/Support_to_children3”, “Section_5_Priority_needs_and_access_to_services/Support_to_children2”, “section_2_general_protection/Please_provide_more_details_on_how_restrictions_on_freedom_of_movement_have_impacted_people_in_your_community_if_you_want_to_share”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_cannot_access_needed_services_or_commodities_what_do_they_do_other_q1”, “section_2_general_protection/headed_hoh_female_above_18_no”, “section_2_general_protection/separated/Male5”, “section_2_general_protection/no_family_members_loc”, “section_3_accountability_to_AAP_community_engagement/What_kind_of_information_does_your_HH_want_to_receive_from_humanitarian_organizations_on_aid_or_services_other”, “section_2_general_protection/survivor”, “section_2_general_protection/Absence_of_state_authorities”, “section_2_general_protection/Latrines”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_document_required”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_document_required_001”, “section_2_general_protection/intend_move_current_location_other_idp_ret”, “Section_6_Referrals/referral_details_health/referral_repeat_health”, “section_2_general_protection/separated/Male13to17”, “section_2_general_protection/Market”, “section_2_general_protection/status_hh_refug”, “section_2_general_protection/status_hh_refug_ret”, “section_2_general_protection/separated/Female13to17”, “Section_5_Priority_needs_and_access_to_services/Nutrition3”, “section_2_general_protection/unaccompanied/Female5_una”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move_other”, “section_2_general_protection/headed_hoh_female_child_above_60_no”, “section_2_general_protection/Presence_of__landmines_ERW__UXOs”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive”, “Section_5_Priority_needs_and_access_to_services/Nutrition2”, “section_2_general_protection/what_are_the_reasons_for_people_in_your_location_to_feel_unsafe_other”, “section_2_general_protection/Gender_based_violence”, “section_2_general_protection/Gender_based_violence_of”, “section_2_general_protection/cause_displacement_other”, “Section_6_Referrals/referral_details_education/referral_repeat”, “Section_6_Referrals/referral_details_legal_support/referral_repeat_legal_support”, “section_2_general_protection/what_are_the_reasons_for_that”, “section_2_general_protection/what_negative_impact_has_this_had_for_your_community”, “section_2_general_protection/What_population_group_has_been_most_affected_by_this_negative_impact”, “section_2_general_protection/community_have_strategies_negative_result_of_tensions”, “section_2_general_protection/Lack_of_access_to_effective_remedy_accountability_mechanisms_for_victims_of_human_rights_violations”, “section_2_general_protection/Schools”, “Section_5_Priority_needs_and_access_to_services/Safety3”, “Section_5_Priority_needs_and_access_to_services/Safety2”, “Section_5_Priority_needs_and_access_to_services/Family_reunification3”, “section_2_general_protection/Health_Facilities”, “section_2_general_protection/Destruction_of_public_infrastructure”, “section_2_general_protection/Occupation_destruction_of_homes”, “section_2_general_protection/At_a_distribution_site”, “section_2_general_protection/Natural_disasters”, "section_2_general_protection/Worry_about_health_and_well_being_due_to_lack_of_services_and_livelihoods”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social_support3”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social_support2”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social_support1”, “Section_5_Priority_needs_and_access_to_services/Nutrition1”, “Section_5_Priority_needs_and_access_to_services/WASH1”, “Section_5_Priority_needs_and_access_to_services/Support_to_children1”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanisms_are_available_in_your_location_site_other”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major_other”, “section_2_general_protection/sources_info_location_intended_other”, “section_2_general_protection/media_sources_hh_other”, “section_2_general_protection/IF_YES_how_many_HHs_arrived_at_this_area”, “section_2_general_protection/where_did_they_come_from_country”, “section_2_general_protection/where_did_they_come_from_state”, “section_2_general_protection/where_did_they_come_from_lga”, “section_2_general_protection/where_did_they_come_from_ward”, “section_2_general_protection/where_did_they_come_from_location_displaced”, “section_2_general_protection/Please_provide_more_details_on_the_displacement”, “section_2_general_protection/Presence_of_armed_Government_forces”, “section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_or_legal_documentation_others”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members_of_your_HH_possess_others”, “section_2_general_protection/unaccompanied/Female13to17_una”, “section_2_general_protection/unaccompanied/Female5to12_una”, “section_2_general_protection/Sexual_exploitation_of_abuse_by_aid_workers”, “section_2_general_protection/other_family_members_loc”, “section_2_general_protection/intend_move_current_location_idp_refugee”, “section_2_general_protection/intend_move_preferred_destination_idp_refugee”, “section_2_general_protection/Disputes_over_land_housing_and_property”, “section_2_general_protection/Actual_secondary_occupation_of_housing_land_or_property”, “section_2_general_protection/Inter_intra_community_tensions”, “section_2_general_protection/Risk_of_human_trafficking”, “Section_6_Referrals/email_addy”, “section_2_general_protection/whom_do_people_in_your_community_report_protection_incidents_to_other”, “section_2_general_protection/Please_provide_more_details_on_the_solution_that_was_found_if_you_want_to_share”, “section_2_general_protection/requirement_move_preferred_location_other”, “section_2_general_protection/intend_move_preferred_destination_other_idp_ret”, “Section_5_Priority_needs_and_access_to_services/Legal_support1”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_impacted_people_in_your_location_other”, “section_2_general_protection/Ethnic_religious_and_or_social_discrimination”, “Section_5_Priority_needs_and_access_to_services/Support_to_women1”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_other”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive_other”, “Section_6_Referrals/referral_details_support_to_women/referral_repeat_support_to_women”, “Section_6_Referrals/referral_details_nutrition/referral_repeat_nutrition”, “Section_6_Referrals/referral_details_support_to_children/referral_repeat_support_to_children”, “Section_6_Referrals/referral_details_wash/referral_repeat_wash”, “Section_5_Priority_needs_and_access_to_services/Safety1”, “section_2_general_protection/what_are_these_strategies_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support2”, “section_2_general_protection/IF_YES_how_many_HHs_left_this_area”, “section_2_general_protection/where_have_they_left_to_country”, “section_2_general_protection/where_have_they_left_to_state”, “section_2_general_protection/where_have_they_left_to_lga”, “section_2_general_protection/where_have_they_left_to_ward”, “section_2_general_protection/where_have_they_left_to_location_displaced”}, {“id", “formhub/uuid”, “start”, “end”, “today”, “deviceid”, “group_general_information/effective_date”, “group_general_information/country”, “group_general_information/state”, “group_general_information/LGA”, “group_general_information/WARD”, “group_general_information/location”, “group_general_information/GPS”, “group_general_information/organisation_code”, “group_general_information/organisation_11”, “group_introduction/Code_of_person”, “group_introduction/respondent_is_major”, “group_introduction/consent”, “group_introduction/language”, “section_2_general_protection/respondent_sex”, “section_2_general_protection/respondent_age”, “section_2_general_protection/C1”, “section_2_general_protection/hoh”, “section_2_general_protection/no_hoh”, “section_2_general_protection/Age”, “section_2_general_protection/C2”, “section_2_general_protection/headed_hoh_male_above_18_no”, “section_2_general_protection/Q1_header/Number”, “section_2_general_protection/Q1_header/Disaggregation_of_members_of_your_HH_that”, “section_2_general_protection/Q1_header/Less_than_5_Years_Female”, “section_2_general_protection/Q1_header/Between_18-25_Years_Female”, “section_2_general_protection/Q1_header/Less_than_5_Years_Male”, “section_2_general_protection/Q1_header/age_group_sum”, “section_2_general_protection/Q1_header/age_group_sum_children_below_17”, “section_2_general_protection/family_members_loc”, “section_2_general_protection/sep_family_members_loc”, “section_2_general_protection/una_family_members_loc”, “section_2_general_protection/are_all_school_aged_children_going_to_school”, “section_2_general_protection/status_hh”, “section_2_general_protection/dis_country”, “section_2_general_protection/dis_state”, “section_2_general_protection/dis_lga”, “section_2_general_protection/dis_ward”, “section_2_general_protection/location_hh”, “section_2_general_protection/hh_current_settlement_type”, “section_2_general_protection/current_shelter_type_1”, “section_2_general_protection/area_origin_country”, “section_2_general_protection/area_origin_state”, “section_2_general_protection/area_origin_lga”, “section_2_general_protection/area_origin_ward”, “section_2_general_protection/location_displaced”, “section_2_general_protection/when_last_displaced”, "section_2_general_protection/How_many_times_have_you_been_displaced_in_the_last”, “section_2_general_protection/what_was_the_cause_of_your_displacement”, “section_2_general_protection/red_flag_1_system”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_ret”, “section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of_di”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_l”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current.1”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current.2”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current.3”, “section_2_general_protection/Can_people_move_around_freely_within_your_current_l”, “section_2_general_protection/Can_people_move_freely_out_of_your_current_location”, “section_2_general_protection/do_members_of_your_HH_possess_civil_and_legal_docum”, “section_2_general_protection/Do_your_HH_members_possess_documents_on_housing_lan”, "section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_or”, “section_2_general_protection/does_any_of_your_HH_members_face_any_problems_becau”, “section_2_general_protection/Has_any_member_of_your_household_experienced_any_pr”, “section_2_general_protection/Are_there_different_population_groups_present_in_yo”, “section_2_general_protection/How_would_you_describe_the_relationship_between_dis”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_informed_about_t”, "section_3_accountability_to_AAP_community_engagement/How_well_does_your_HH_feel”, “section_3_accountability_to_AAP_community_engagement/Food_assistance”, “section_3_accountability_to_AAP_community_engagement/Nutrition_assistance”, “section_3_accountability_to_AAP_community_engagement/Shelter_assistance”, “section_3_accountability_to_AAP_community_engagement/NFI_assistance”, “section_3_accountability_to_AAP_community_engagement/WASH_assistance”, “section_3_accountability_to_AAP_community_engagement/Education_assistance”, “section_3_accountability_to_AAP_community_engagement/Health_assistance”, “section_3_accountability_to_AAP_community_engagement/Services_for_GBV_survivors”, “section_3_accountability_to_AAP_community_engagement/Services_for_children_in_ne”, “section_3_accountability_to_AAP_community_engagement/Legal_services”, "section_3_accountability_to_AAP_community_engagement/Mental_Health_Psychosocial”, “section_3_accountability_to_AAP_community_engagement/Livelihood_services”, “section_3_accountability_to_AAP_community_engagement/What_kind_of_information_do”, “section_3_accountability_to_AAP_community_engagement/What_would_be_your_HHs_pref”, “section_3_accountability_to_AAP_community_engagement/Community_leaders”, “section_3_accountability_to_AAP_community_engagement/Does_your_HH_feel_that_it_i”, “section_3_accountability_to_AAP_community_engagement/Do_you_feel_the_kind_of_ser”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_aware_of_ways_to”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and_p”, “section_3_accountability_to_AAP_community_engagement/Has_your_HH_ever_used_any_o”, “section_3_accountability_to_AAP_community_engagement/did_you_receive_any_feedbac”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_peo”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_that_yo”, "Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_an”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_relationship_be”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/An_exchange_of_good_serv”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_aid”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_of_a_me”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanis”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Among_those_reporting_me”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/would_your_hh_feel_confi”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/report_sexual_misconduct”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Basic_material_assistanc”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Medical_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Psycho_social_support”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Legal_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Safe_shelter”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Reintegration_in_the_com”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/DNA_paternity_identifica”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitarian”, “Section_5_Priority_needs_and_access_to_services/Priority_No_1”, “Section_5_Priority_needs_and_access_to_services/condition_1”, “Section_5_Priority_needs_and_access_to_services/NFIs1”, “Section_5_Priority_needs_and_access_to_services/Priority_No_2”, “Section_5_Priority_needs_and_access_to_services/condition_2”, “Section_5_Priority_needs_and_access_to_services/Food2”, “Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “Section_5_Priority_needs_and_access_to_services/condition_3”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training3”, “Section_6_Referrals/Does_the_HH_require_a_referral_to_service_providers”, “Section_6_Referrals/From_the_information_you_have_shared_I_can_see_that_y”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major”, “Section_6_Referrals/Comments_to_be_filled_out_by_the_protection_monitor_major”, “Section_6_Referrals/referral_details_nfis/referral_repeat_nfis”, “version”, “meta/instanceID”, “xform_id_string", “uuid", “attachments", “status", “geolocation", “submission_time", “tags", “notes", “validation_status", “submitted_by", “section_2_general_protection/Q1_header/Between_26-59_Years_Female”, “section_2_general_protection/headed_hoh_male_child_above_60_no”, “section_2_general_protection/Q1_header/Between_5-12_Years_Female”, “section_2_general_protection/headed_hoh_female_above_18”, “section_2_general_protection/Q1_header/Between_13-17_Years_Female”, “section_2_general_protection/Q1_header/Between_5-12_Years_Male”, “section_2_general_protection/Q1_header/Between_13-17_Years_Male”, "section_2_general_protection/Are_women_among_those_HH_members_who_possess_civil”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members_o”, “Section_6_Referrals/Last_name”, “Section_6_Referrals/FIrst_name”, “section_2_general_protection/Q1_header/Between_18-25_Years_Male”, “section_2_general_protection/what_are_the_reasons_for_children_not_going_to_scho”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of”, "section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack.1”, “Section_6_Referrals/phone_num”, “section_2_general_protection/Q1_header/Between_26-59_Years_Male”, “Section_5_Priority_needs_and_access_to_services/NFIs3”, "Section_5_Priority_needs_and_access_to_services/Priority_No_1”, "Section_5_Priority_needs_and_access_to_services/Priority_No_2”, "Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “section_2_general_protection/child_at_rist”, “section_2_general_protection/elderly_at_rist”, “section_2_general_protection/none_of_the_HH_members_is_vulnerable”, “Section_5_Priority_needs_and_access_to_services/Food1”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training2”, “Section_5_Priority_needs_and_access_to_services/Shelter1”, “Section_5_Priority_needs_and_access_to_services/NFIs2”, “section_2_general_protection/intend_move_current_location_idp_ret”, “section_2_general_protection/intend_move_preferred_destination_idp_ret”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move”, “section_2_general_protection/when_do_you_want_to_move_to_country”, “section_2_general_protection/when_do_you_want_to_move_to_state”, “section_2_general_protection/when_do_you_want_to_move_to_lga”, “section_2_general_protection/when_do_you_want_to_move_to_ward”, “section_2_general_protection/location_move_to”, “section_2_general_protection/intend_move_current_access_info”, “section_2_general_protection/info_hh_make_decision_preferred_location”, “section_2_general_protection/requirement_move_preferred_location”, “section_2_general_protection/sources_info_location_intended”, “section_2_general_protection/current_location_hh”, “section_2_general_protection/media_sources_hh”, “section_2_general_protection/Fredom_group_001/freedom_movement_questions_001”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_im”, “section_2_general_protection/Do_people_in_your_location_report_these_restriction”, “section_2_general_protection/Who_do_they_generally_report_these_restrictions_to”, “section_2_general_protection/when_people_in_your_community_reported_any_of_these”, “section_3_accountability_to_AAP_community_engagement/Village_elders”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_p.1”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechan.1”, “Section_5_Priority_needs_and_access_to_services/WASH3”, “Section_5_Priority_needs_and_access_to_services/WASH2”, “Section_5_Priority_needs_and_access_to_services/Food3”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and.1”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training1”, “section_2_general_protection/women_at_rist”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_refugee”, "section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of.1”, “section_3_accountability_to_AAP_community_engagement/Religious_leaders”, “Section_5_Priority_needs_and_access_to_services/Shelter3”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_acce”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_cann”, “Section_6_Referrals/referral_details_food/referral_repeat_food”, “Section_6_Referrals/referral_details_livelihood_vocational_training/referral_rep”, “Section_6_Referrals/referral_details_shelter/referral_repeat_shelter”, “Section_5_Priority_needs_and_access_to_services/Shelter2”, “Section_6_Referrals/dob”, “Section_6_Referrals/comments”, “section_2_general_protection/requirement_move_preferred_location_other_001”, “section_2_general_protection/what_are_the_reasons_for_people_in_your_location_to”, “section_2_general_protection/Attacks_against_the_population”, “section_2_general_protection/Risk_of_abduction_and_demands_for_ransom”, “section_2_general_protection/In_which_of_the_following_locations_do_all_communit”, “section_2_general_protection/In_the_fields_when_fetching_firewood_water_scrap_me”, “section_2_general_protection/In_the_fields_when_doing_farming”, “section_2_general_protection/Does_your_community_have_strategies_to_deal_with_th”, “section_2_general_protection/when_did_the_HH_member_experience_the_protection_in”, “section_2_general_protection/type_of_incid_tookplace/type_of_incid_tookplace_que”, "section_2_general_protection/whom_do_people_in_your_community_report_protection”, “section_2_general_protection/did_the_HH_members_affected_by_the_protection_incid”, “Section_5_Priority_needs_and_access_to_services/Education3”, “section_2_general_protection/child_at_rist_school”, “section_2_general_protection/separated/Number_sep”, “section_2_general_protection/separated/Dissaggregation_of_children_within_your_H”, “section_2_general_protection/separated/Female5”, “section_2_general_protection/separated/Female5to12”, “section_2_general_protection/separated/Male5to12”, “section_2_general_protection/separated/number_separated_sum”, “section_2_general_protection/serious_med_cond”, “section_2_general_protection/are_women_among_those_possessing_HLP_documentation”, “section_2_general_protection/what_type_of_HLP_documents_do_your_HH_members_posse”, “section_2_general_protection/headed_hoh_male_child_above_60”, “section_2_general_protection/headed_hoh_male_above_18”, “section_2_general_protection/Q1_header/Above_60_Years_Female”, “section_2_general_protection/Q1_header/Above_60_Years_Male”, “section_2_general_protection/disabilities”, “section_2_general_protection/headed_hoh_female_child_above_60”, “section_2_general_protection/current_shelter_type_2”, “Section_5_Priority_needs_and_access_to_services/Education1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property3”, “Section_5_Priority_needs_and_access_to_services/Health3”, “Section_5_Priority_needs_and_access_to_services/Health2”, “Section_5_Priority_needs_and_access_to_services/Education2”, “section_2_general_protection/unaccompanied/Number_una”, “section_2_general_protection/unaccompanied/Dissaggregation_of_children_within_yo”, “section_2_general_protection/unaccompanied/Male5_una”, “section_2_general_protection/unaccompanied/number_unaccompanied_sum”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitari.1”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_ac.1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property2”, “section_2_general_protection/In_some_blocks_of_the_camp_community”, “section_2_general_protection/Proximity”, “section_2_general_protection/Presence_of__NSAGs”, “section_2_general_protection/Criminal_activities_in_the_area”, “section_2_general_protection/In_some_streets_of_the_camp_community”, “section_2_general_protection/Within_their_house_tent”, “section_2_general_protection/what_are_these_strategies”, “section_2_general_protection/Fredom_group/freedom_movement_questions”, “Section_5_Priority_needs_and_access_to_services/Health1”, “section_2_general_protection/hh_current_settlement_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women2”, “Section_5_Priority_needs_and_access_to_services/Support_to_children3”, “Section_5_Priority_needs_and_access_to_services/Support_to_children2”, "section_2_general_protection/Please_provide_more_details_on_how_restrictions_on”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_ca.1”, “section_2_general_protection/headed_hoh_female_above_18_no”, “section_2_general_protection/separated/Male5”, “section_2_general_protection/no_family_members_loc”, "section_3_accountability_to_AAP_community_engagement/What_kind_of_information.1”, “section_2_general_protection/survivor”, “section_2_general_protection/Absence_of_state_authorities”, “section_2_general_protection/Latrines”, "section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack.2”, "section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack.3”, “section_2_general_protection/intend_move_current_location_other_idp_ret”, “Section_6_Referrals/referral_details_health/referral_repeat_health”, “section_2_general_protection/separated/Male13to17”, “section_2_general_protection/Market”, “section_2_general_protection/status_hh_refug”, “section_2_general_protection/status_hh_refug_ret”, “section_2_general_protection/separated/Female13to17”, “Section_5_Priority_needs_and_access_to_services/Nutrition3”, “section_2_general_protection/unaccompanied/Female5_una”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move_other”, “section_2_general_protection/headed_hoh_female_child_above_60_no”, “section_2_general_protection/Presence_of__landmines_ERW__UXOs”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive”, “Section_5_Priority_needs_and_access_to_services/Nutrition2”, "section_2_general_protection/what_are_the_reasons_for_people_in_your_location.1”, “section_2_general_protection/Gender_based_violence”, “section_2_general_protection/Gender_based_violence_of”, “section_2_general_protection/cause_displacement_other”, “Section_6_Referrals/referral_details_education/referral_repeat”, “Section_6_Referrals/referral_details_legal_support/referral_repeat_legal_support”, “section_2_general_protection/what_are_the_reasons_for_that”, “section_2_general_protection/what_negative_impact_has_this_had_for_your_communit”, “section_2_general_protection/What_population_group_has_been_most_affected_by_thi”, “section_2_general_protection/community_have_strategies_negative_result_of_tensio”, “section_2_general_protection/Lack_of_access_to_effective_remedy_accountability_m”, “section_2_general_protection/Schools”, “Section_5_Priority_needs_and_access_to_services/Safety3”, “Section_5_Priority_needs_and_access_to_services/Safety2”, “Section_5_Priority_needs_and_access_to_services/Family_reunification3”, “section_2_general_protection/Health_Facilities”, “section_2_general_protection/Destruction_of_public_infrastructure”, “section_2_general_protection/Occupation_destruction_of_homes”, “section_2_general_protection/At_a_distribution_site”, “section_2_general_protection/Natural_disasters”, “section_2_general_protection/Worry_about_health_and_well_being_due_to_lack_of_se”, "Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_socia.1”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_socia.2”, “Section_5_Priority_needs_and_access_to_services/Nutrition1”, “Section_5_Priority_needs_and_access_to_services/WASH1”, “Section_5_Priority_needs_and_access_to_services/Support_to_children1”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechan.2”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major_other”, “section_2_general_protection/sources_info_location_intended_other”, “section_2_general_protection/media_sources_hh_other”, “section_2_general_protection/IF_YES_how_many_HHs_arrived_at_this_area”, “section_2_general_protection/where_did_they_come_from_country”, “section_2_general_protection/where_did_they_come_from_state”, “section_2_general_protection/where_did_they_come_from_lga”, “section_2_general_protection/where_did_they_come_from_ward”, “section_2_general_protection/where_did_they_come_from_location_displaced”, “section_2_general_protection/Please_provide_more_details_on_the_displacement”, “section_2_general_protection/Presence_of_armed_Government_forces”, “section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_o.1”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members.1”, “section_2_general_protection/unaccompanied/Female13to17_una”, “section_2_general_protection/unaccompanied/Female5to12_una”, “section_2_general_protection/Sexual_exploitation_of_abuse_by_aid_workers”, “section_2_general_protection/other_family_members_loc”, “section_2_general_protection/intend_move_current_location_idp_refugee”, “section_2_general_protection/intend_move_preferred_destination_idp_refugee”, “section_2_general_protection/Disputes_over_land_housing_and_property”, “section_2_general_protection/Actual_secondary_occupation_of_housing_land_or_prop”, “section_2_general_protection/Inter_intra_community_tensions”, “section_2_general_protection/Risk_of_human_trafficking”, “Section_6_Referrals/email_addy”, “section_2_general_protection/whom_do_people_in_your_community_report_protectio.1”, “section_2_general_protection/Please_provide_more_details_on_the_solution_that_wa”, “section_2_general_protection/requirement_move_preferred_location_other”, “section_2_general_protection/intend_move_preferred_destination_other_idp_ret”, “Section_5_Priority_needs_and_access_to_services/Legal_support1”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_.1”, “section_2_general_protection/Ethnic_religious_and_or_social_discrimination”, “Section_5_Priority_needs_and_access_to_services/Support_to_women1”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_.4”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive_o”, “Section_6_Referrals/referral_details_support_to_women/referral_repeat_support_to”, “Section_6_Referrals/referral_details_nutrition/referral_repeat_nutrition”, “Section_6_Referrals/referral_details_support_to_children/referral_repeat_support”, “Section_6_Referrals/referral_details_wash/referral_repeat_wash”, “Section_5_Priority_needs_and_access_to_services/Safety1”, “section_2_general_protection/what_are_these_strategies_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support2”, “section_2_general_protection/IF_YES_how_many_HHs_left_this_area”, “section_2_general_protection/where_have_they_left_to_country”, “section_2_general_protection/where_have_they_left_to_state”, “section_2_general_protection/where_have_they_left_to_lga”, “section_2_general_protection/where_have_they_left_to_ward”, “section_2_general_protection/where_have_they_left_to_location_displaced”})
in
#“Expanded Column1”
@baana2005, I understood your problem, your excel file is working fine, you can update it without any problem, but you can’t update the Power BI file because of the some missing columns in excel file. So these columns you mentioned is not included in the JSON link you shared, but those columns are used in Power BI steps, Power BI steps are not dynamic, so that if you exclude any column from the file/link, you also need to delete them from the advance editor manually. In the picture below you will see, i was able to update the data successfully in the excel file and the Power BI. In the second picture you will see this column is not in the data set so you need to delete anything related to this column in advance editor. If you click the go to error button it will take you to step where the mistake is, as you can see in the third picture, you need to delete that name. You need to repeat this step as long as power bi not throwing error. As you can see in the last picture after deleting those, i was able to update the data set.
The question is how this column names are disappeared from your data set? Did you delete questions? or did you exclude them form the download selection panel? etc etc.
Pic 1:
Pic 2:
Pic 3:
Pic 4:
1 Like
Dear @osmanburcu ,
Thank you for always looking to solved my problem,
I have read what you wrote and the issue is I needed that column named section_2_general_protection/Risk_of_recruitment_by_NSAGs because is vital column, If I download the file via kobo server XLS excel file XML values and headers or labels I will see the column, now If you can fixed the downloadable link of the excel so that it will recall all columns from kobo server I will much appreciate it, if your free we can have a Skype call via my Skype I.D: baana2005
**The links which I am using to download which you previously assist in limiting it **
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=0&limit=20000
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=20001
The excel XML values and headers which if you search you will see the missing column is there, I really needed all columns that are on kobo server to appear in the excel export then power BI will read them.
Thank you.
@baana2005 the problem is more complicated than i expected because you have around 1700 column in your dataset. There was problem from the kobo side as well as power bi side. I believe i was able to solve the Kobo side. What you need to do now is,
find the columns that are blocking you form the refresh the Power BI, in this case it was “section_2_general_protection/intend_move_current_location_other_idp_refugee”.
Go to excel and power query, open the advance editor for these two table “?start=0&limit=20000”, “?start=20001”, then you need to add these column names to advance editor.
in advance editor, you need to write the column name twice, one bofere the “}” and other after “{”.
as soon as you add the correct column name, column should appear in your excel sheet. You need to this for these two tables. after you add the column to table, just refresh the cumulative table and it will include this information. You need to do this step for all missing columns. I hope this solve your problem, because i am not sure if i have any other answer for your problem. I have been thinking and working on it in last 24hours
1 Like
Dear @osmanburcu ,
Thank you for this manual procedure which I am correctly adding any column my Power BI request, the problem with this manual is that I need to open power query in excel add the single column requested at a time by Power BI then close the excel and open Power BI to see the next column it will requested, if you took at it you will know that It will take me long time to finally finished adding the requested columns, I will request either you @osmanburcu or @Kal_Lam to fix it the regular way that if someone export data it will automatically comes with all columns, I will appreciate if you can swiftly rectify the automatic way. Thank you.
Dear Ali, this is really unique case i believe, because of the column number you have, the data you collected.
One easire solution is, delete the first changed type step in the applied steps. Because this is an automatic process by Power BI and most of your mistakes are in this step, deleting this step probabaly won’t aftect your data at all except the date columns or some int column. You can arrange it later. This will suppose to shorten your work load.
Another Solution that i could suggest:
What i could suggest you as easier option is, instead of adding them one by one, download your data in XML values, copy the column names, transform them similat to advance editor format and paste it directly to advance editor.
1 Like
I am unable to get the token. was it somehow concealed?
