Which Connector for a Teams Power Apps Project Report?

PL-300 By islever Editorial Last updated

Get or connect to data

Short answer

C Select the Microsoft Dataverse connector because a Power Apps project management app hosted in Teams stores its data in Dataverse for Teams.

Question

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?
  1. Microsoft Teams Personal Analytics
  2. SQL Server database
  3. Dataverse Correct Answer
  4. Dataflows

Key Takeaways

The question tests identifying the backing data store of a Teams-hosted Power Apps solution; the trap is choosing a connector named after Teams (Personal Analytics) or a generic ingestion feature (dataflows) instead of the actual storage platform.

A project management app built with Microsoft Power Apps and hosted entirely in Microsoft Teams stores its data in Dataverse for Teams, so the Power BI report must use the Microsoft Dataverse connector. This page confirms that Dataverse (option C) is the correct selection and explains why Teams Personal Analytics, SQL Server, and dataflows do not apply.

Common mistake: Option A, Microsoft Teams Personal Analytics, is the most tempting wrong pick because the app is described as being 'fully hosted in Microsoft Teams,' but that connector surfaces Teams usage/activity signals rather than the relational tables a Power Apps model writes to.

Expert Analysis

Why the Answer Is Correct

Power Apps built for Microsoft Teams are provisioned on Dataverse for Teams, a low-code relational data platform that lives inside the Teams environment and stores every table the app creates. As lizbette noted, "Microsoft Dataverse for Teams is a built-in, low-code data platform for Microsoft Teams" that "lets users build custom apps, bots, and flows in Microsoft Teams by using Power Apps." Because the app's data physically resides in Dataverse, the Microsoft Dataverse connector is the only option that lets Power BI read those tables directly. This also matches srikanth923's reasoning that Dataverse lets you "use the data from the business applications such as Microsoft teams directly in power bi." The relationship is one-to-one: Power Apps authoring platform determines the backing store, and the backing store determines the connector.

Why the Other Options Are Wrong

Option A, Microsoft Teams Personal Analytics, reports on an individual's Teams collaboration activity — meetings, chats, and calls — not on custom business tables written by a Power Apps solution, so it would return no project records. Option B, SQL Server database, would be correct only if the app were backed by an Azure SQL or on-premises SQL instance, which the scenario never states; Power Apps in Teams defaults to Dataverse for Teams rather than SQL. Option D, Dataflows, is not a data source at all — as LOCOBI pointed out, "Dataflows is the configuration of the manipulation of data," i.e., a preparation and ingestion feature that would still need Dataverse as its underlying source, making it a second hop rather than the connector to select.

Community Comment Notes

The community converges strongly on C, with lizbette, Shalaleh, srikanth923, Saluk_DE, AK055, lukelin08, and eckip all selecting Dataverse, and Igetmyrole spelling out that the answer is C "because it is a database platform often used in conjunction with power apps." Abasifreke's top-voted comment points to the Power BI Project for the web template that connects to "your Microsoft Dataverse instance, where your Microsoft Project web app data is stored" — useful supporting evidence that Dataverse is Microsoft's default store for project-type apps, though that template addresses Project for the web rather than a custom Power Apps solution.

Official Reference

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro

This link opens the official vendor documentation in a new tab.

Exam Strategy

On PL-300 connector questions, identify the system of record implied by the scenario before reading the options: the authoring tool (Power Apps in Teams) signals Dataverse, an external ERP signals SQL/SAP, and a movement feature (dataflows) is never the answer to a 'which connector' question.

Frequently Asked Questions

Why is Microsoft Teams Personal Analytics not the right connector here?

Teams Personal Analytics reports on meetings, chats, and call activity, not on custom business tables. Your project records live in Dataverse, so that connector would return nothing relevant.

Could I use Dataflows instead of the Dataverse connector?

Dataflows are a preparation and refresh feature, not a source. You would still have to point the dataflow at Dataverse, making it an unnecessary extra step for a direct report connection.

More PL-300 FAQ →

Discussion 38 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 30 of 38

  1. Abasifreke 👍 38
    You can use the Microsoft Power BI template to import data into Power BI from Project for the web and Project Online. When you're using the template, you're connected to your Microsoft Dataverse instance, where your Microsoft Project web app data is stored.
  2. lizbette 👍 21 Answered C
    Microsoft Dataverse for Teams is a built-in, low-code data platform for Microsoft Teams that lets users build custom apps, bots, and flows in Microsoft Teams by using Power Apps, Power Virtual Agents, and Power Automate. Dataverse for Teams—built on Microsoft Dataverse—provides relational data storage, rich data types, enterprise-grade governance, and one-click solution deployment to the Microsoft Teams app store.
  3. LOCOBI 👍 5
    Dataflows is the configuration of the maniuplation of data. Microsoft Dataverse for Teams is a built-in, low-code data platform for Microsoft Teams that lets users build custom apps, bots, and flows in Microsoft Teams by using Power Apps.I f your project management app is built using Power Apps and stores its data in Dataverse.
  4. Igetmyrole 👍 4
    The correct answer is C (Dataverse) because it is a database platform often used in conjunction with power apps. In other words, if your project management app is built using Power Apps and stores its data in Dataverse.
  5. srikanth923 👍 4 Answered C
    The answer is C. Dataverse allows you to use the data from the business applications such as Microsoft teams directly in power bi.
Show 25 more comments
  1. lukelin08 👍 3 Answered C
    C, Dataverse is correct
  2. eckip 👍 3 Answered C
    correct
  3. omath 👍 2 Answered C
    Correct Answer: C. Dataverse Explanation: Power Apps apps hosted in Microsoft Teams store their data in Dataverse for Teams. To connect Power BI to that app’s data, you use the Dataverse connector, which provides direct access to the underlying tables. Other options: A. Microsoft Teams Personal Analytics → Only for Teams usage metrics, not app data. B. SQL Server database → Not applicable unless the app uses SQL backend (it doesn’t here). D. Dataflows → Used for ETL and staging, not direct connection to the app’s data source.
  4. Dani_eL 👍 2 Answered C
    When using Microsoft Power BI template , you're connected to your Microsoft Dataverse instance
  5. rcaliandro 👍 2 Answered C
    Dataverse is the correct one
  6. MagicMan99 👍 2
    The answer is C
  7. TrustMyAnswers 👍 2 Answered C
    Dataverse.
  8. Lulu_2022 👍 1 Answered C
    To connect Power BI to a project management app built with Power Apps in Microsoft Teams, you should use the Microsoft Dataverse for Teams connector. ✅ Why? When you build a Power App inside Teams, it stores its data in a lightweight version of Dataverse called Dataverse for Teams. Power BI can connect to this data using the Dataverse connector, but you’ll need to: Identify the correct environment (each Teams app has its own Dataverse environment). Use the Dataverse (legacy) or Dataverse connector in Power BI Desktop. Authenticate and select the appropriate tables (they often start with the prefix ms_ or custom_). > 🔐 Note: You must have appropriate permissions in Teams and Dataverse to access the data.
  9. Harshith_VC6362 👍 1 Answered C
    A. Microsoft Teams Personal Analytics This is only for personal usage analytics (messages, meetings, calls) inside Teams. Not app data. B. SQL Server database Power Apps in Teams does not directly store data in SQL Server unless explicitly configured. Not needed here. C. Dataverse This is the underlying data platform for Power Apps and Power Apps for Teams. It stores the app’s data. Power BI can directly connect to Dataverse to fetch data from the app. This is the correct answer. D. Dataflows Dataflows are for ETL and preparing data before loading into Power BI, but they do not directly connect to the underlying app unless already set up.
  10. HarshilT 👍 1 Answered C
    Since the project management app is developed using Power Apps and hosted in Microsoft Teams, it most likely stores its data in Microsoft Dataverse for Teams (a lightweight version of Dataverse designed specifically for Teams environments). Dataverse is the backend data platform for Power Apps. Power BI can directly connect to Dataverse to pull data for reporting. This allows to build rich, interactive reports using the same tables and data used by Power App.
  11. bebaj 👍 1 Answered C
    Microsoft Power BI template to import data into Power BI from Project for the web and Project Online. When you're using the template, you're connected to your Microsoft Dataverse instance, where your Microsoft Project web app data is stored. REF : https://techcommunity.microsoft.com/discussions/azure/pl-300-exam/4289932
  12. MOG1 👍 1 Answered A
    QS. you need to create the dataset. which dataset mode should you use = IMPORT/COMPOSITE QS. You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.= PIE CHART / BAR CHART please which answer is correct from the 2 qs above
  13. growthsieg 👍 1 Answered C
    x Microsoft teams Analytics -pulls Teams usage data (meetings, calls, chats) — not app data xDataflows -->Dataflows are a Power BI data prep feature, not a source connector x SQL Server -->Power Apps doesn't store data in SQL Server by default ,CUSTOM SETUP NEEDED so DATAVERSE LEFT
  14. marqs_lih 👍 1 Answered C
    Quando você cria um Power App diretamente no ambiente do Teams, a Microsoft utiliza uma versão simplificada de sua plataforma de dados padrão, que é totalmente integrada. Essa plataforma de dados se chama Microsoft Dataverse (antigamente conhecida como Common Data Service).
  15. SwaH119 👍 1 Answered C
    Microsoft Power BI template to import data into Power BI from Project for the web and Project Online. When you're using the template, you're connected to your Microsoft Dataverse instance, where your Microsoft Project web app data is stored.
  16. alojt 👍 1
    Amazing stuff! This is exactly what I needed :D Great Q&A material I can test my knowledge on. @Abasifreke Thank you for the short summary and providing us with the link.
  17. jmoralesn2 👍 1 Answered C
    Apps created in Teams using Power Apps store data in Dataverse, thus the best connector would be the built-in connector for Dataverse
  18. Hosna2023 👍 1 Answered C
    Dataverse is a secure storage place that organizes and holds all the data for apps built with Power Apps.
  19. Lynda_Lin 👍 1 Answered C
    ....................................................
  20. Risenga 👍 1 Answered A
    Because the data is stored on teams
  21. saarah9 👍 1 Answered C
    Power Apps store data in Dataverse
  22. Winner2099 👍 1
    C Data verse is correct
  23. Nurgul 👍 1 Answered C
    I think it's Dataverse
  24. c11bdc3 👍 1 Answered C
    Microsoft Dataverse
  25. Guiksp 👍 1 Answered C
    C is good answer

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

PREVIOUSYEAR returns the full previous year, not the same day of last year

S-grade

Shrinking a Power BI model for monthly transaction totals with a star schema

S-grade

Northwind Traders semantic model: choosing Import storage mode for the Power BI tables

S-grade

Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector

S-grade

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide