A company has an on-premises data warehouse and analytics solution- The data warehouse consists of...

A company has an on-premises data warehouse and analytics solution- The data warehouse consists of multiple multi-dimensional data cubes representing over five years of operational data. The data warehouse consolidates and normalizes data that is sourced from 20 different systems.

The company plans to replace the existing solution with a Microsoft Power Platform solution that connects to the data warehouse. The company wants to provide analytical information to executives in a Microsoft Teams channel to support business planning.

The new solution must meet these requirements:

Support the current data warehouse.

The solution must support drill-through capabilities into the data.

You need to recommend a solution.

What should you recommend? To answer, select the appropriate options m the answer area. NOTE: Each correct selection is worth one point.