Microsoft Certified: Power BI Data Analyst Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  Correct answer: - Report file: LiveConnect - Dataset/semantic model file: Import Why it is correct: The Excel workbooks must be loaded and combined into the semantic model, so the semantic model file uses Import mode; Excel isn’t a DirectQuery source in this scenario. To publish a separate report and semantic model, the report PBIX should connect to the already-published semantic model using a live connection, which Microsoft specifically recommends for separating reports from models. https://learn.microsoft.com/en-us/power-bi/guidance/report-separate-from-model

• 1

  I think the answers are wrong: An excel file cannot load with direct query because it hasn't a query engine. Report has to be in live coonection. Once you have load the semantic model in Fabric, inside the workspace io ca create report in live conncetion for that semnatic model

• 1

  La clave está en el enunciado El enunciado dice simplemente: "publicar un informe y un dataset por separado", sin necesidad de combinar fuentes adicionales. LiveConnect es la solución más directa y correcta para ese requisito específico. En los exámenes de Microsoft, cuando el escenario es exactamente "separar informe de dataset sin combinación de fuentes adicionales", la respuesta esperada es siempre LiveConnect, no DirectQuery to datasets. DirectQuery to Power BI datasets sería correcto si el enunciado dijera algo como "combinar el dataset publicado con otra fuente adicional".