Skip to content
TheChatArchiveThe Chat Archive
Human-written demonstration (OpenAssistant volunteers)· OpenAssistant (human-written)Hugging Face OpenAssistant Conversations (oasst2)

How to clean input data in Microsoft Power BI?

In OpenAssistant data, “assistant” turns were written by human volunteers as demonstrations. They are not model outputs.
  1. User

    How to clean input data in Microsoft Power BI?

  2. Assistant

    You can clean input data in Microsoft Power BI using Power Query. It has an incredible amount of features that are dedicated to helping you clean and prepare your data for analysis.

    You can simplify a complicated model, change data types, rename objects, and pivot data. You can also use functions like Trim under Transform > Format in the Power Query Editor to remove spaces from the beginning and end of text values.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.