The solution must not affect the precision of the data. What should you do?

Last Updated on October 23, 2021 by Admin 3

You have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

DA-100 Analyzing Data with Microsoft Power BI Part 03 Q18 078
DA-100 Analyzing Data with Microsoft Power BI Part 03 Q18 078

The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.

What should you do?

  • Split the DateTime column into separate date and time columns.
  • Change the data type of the DateTime column to Date.
  • Change the data type of the Latitude column to Fixed Decimal.
  • Disable the Power Query load.
Explanation:
Disable Power Query query load.
Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments