Fill in the blank with the correct answer:Power PivotPower Query Editor3D Maps (Power Map)Relationship builderblank1 - Word AnswerWrite your response here... : is the tool that we should use to remove fields and format data when importing.

How do you get Power BI Desktop to find relationships in data after importing? Open the Power Query EditorSelect Manage Relationships and then AutodetectTo map the relationship, select the New Parameter buttonUse the Performance Manager

Where do you create relationships between tables in Power Pivot?Options :In data viewIn diagram viewIn Design viewRelationships are automatically created during data import

Question 4True or False.One must convert the dataset into a csv format before importing into Power BI. 1 pointTrueFalse

In using Power Query, you notice that a field of data is not joining with data that appears the same. You have already removed trailing and leading spaces. What cleaning command should you consider next?

What is the purpose of creating relationships between tables in Power Pivot?Options :To merge tables into oneTo establish connections with external databasesTo enable more complex calculations and analysisTo import data from web sources