Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Microsoft Form Multiple Choice to Power BI: Standardising Answers

Hi   I have a list of over a 1000 stakeholders that I need people using my Microsoft Forms to input correctly so this data can then be pulled onto my Power BI dashboard. My issue is that Microsoft ...
Need Help
Tips and Tricks
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Anonymous  You can use Power Query in Power BI to clean and standardize names, applying transformations like capitalization and fuzzy matching to align entries with your approved list. Alternatively, use Excel Data Validation to restrict inputs or highlight mismatches for correction. Power Automate can preprocess entries by comparing and standardizing names before they reach Power BI. 

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi Anonymous  You can use Power Query in Power BI to clean and standardize names, applying transformations like capitalization and fuzzy matching to align entries with your approved list. Alternatively, use Excel Data Validation to restrict inputs or highlight mismatches for correction. Power Automate can preprocess entries by comparing and standardizing names before they reach Power BI. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks Akash_Varuna , these are really interesting suggestions. Do you know of any good tutorial videos or anything on how to set up Power Query to clean up and standardise the names before they hit Power BI? I tried google and YouTube but I'm not finding what I'm looking for. 

     

    Appreciate everyones help on this!