You install Microsoft Power BI Publisher for Excel. You need to use Excel to connect and analyze Power BI data. To which two types of Power BI data can you connect? Each correct answer presents a…

The correct answer is B. datasets C. reports. Analyze in Excel is very useful for datasets and reports that connect to Analysis Services Tabular or Multidimensional databases, or from Power BI Desktop files or Excel workbooks with data models that have model measures created using Data Analysis Expressions (DAX)…

Consume and transform data by using Microsoft Excel

Question

You install Microsoft Power BI Publisher for Excel. You need to use Excel to connect and analyze Power BI data. To which two types of Power BI data can you connect? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options

Aapps
Bdatasets
Creports
Ddashboard

How the community answered

(18 responses)

A
6% (1)
B
78% (14)
D
17% (3)

Explanation

Analyze in Excel is very useful for datasets and reports that connect to Analysis Services Tabular or Multidimensional databases, or from Power BI Desktop files or Excel workbooks with data models that have model measures created using Data Analysis Expressions (DAX). https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

Topics

#Power BI Publisher#datasets#reports#Excel connectivity

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice