Microsoft Teams Tasks Export

Power Query
1

Hey DNA Team,

Has anyone, imported Microsoft Teams Tasks directly into PowerBi before? I know I can export to excel from Planner. But, I would like to skip that step an connect directly to the live source or something a can refresh easily.

Thanks in advance.

Adam

1 Like
2

you likely can as they are both microsoft products. Did you do a youtube search?

PS…there are a lot of videos on youtube

3

Hi Keith,

Yes, I did search around; and yes you would have thought it would obvious, considering you can now bring PowerBi into teams.

Simply getting my teams tasks, due date, assigned people, etc…seems to be evading me.

Thanks, Adam

4

i just typed in “microsoft team tasks import into power bi directly” in the youtube search there are few videos that came up.

you might not get everything in one video but it would likely give you some other ideas too
thanks Keith

5

Hi Keith,

No, none of those videos show how its done.

Thanks, Adam

6

ok…looks kinda interesting :slight_smile:

7

@adam ,

The native Teams/PBI integration ain’t great. As far as I know, there’s just one connector in beta form that captures the following three tables. I ran this on my Teams data and then unpivoted the columns so you could see the general structure of each table.

Unfortunately, I don’t think this gets you what you want.

  • Brian

  1. Teams Usage:
    image

  2. Teams Usage Summary:
    image

  3. Teams User Activity

    image
    image718Ă—574 32.6 KB

8

Hi @adam ,

You might have to look into the Graph API…

I hope this is helpful.

1 Like
9

Hi @adam, did the response provided by the users and experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

10

Hi @adam, we’ve noticed that no response has been received from you since the 1st of June. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

11

Hi @adam, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!