Forum Discussion

Nawal_75's avatar
Nawal_75
New Member
3 years ago
Solved

Link TEAMS & Power BI

Hello !

 

I am a very beginner with Power BI, so i am moving slowly for the moment,

 

I am working with Excel files loaded in TEAMS, and I would like to connect those files to Power BI,

Is it possible without loading them locally ? (I don't have Power BI pro)

And I can see that if I modify the excel file, it is possible to update the Power BI, but I don't understand how,

 

Thanks in advance !

Nawal

Need Help
  • ray_aramburo's avatar
    ray_aramburo
    3 years ago

    It is possible as long as your Teams group isn't private. Each Teams group has a Sharepoint site behind where those files are stored. Open that file on the desktop app, go to File > Info > Copy Path. 

    Then, on Power BI, go to Get Data > Web and paste that link erasing the last piece which is something like ?=web1 (the link has to end after the .xlsx) and that's it. 

1 Reply

  • ray_aramburo's avatar
    ray_aramburo
    Super User
    3 years ago

    It is possible as long as your Teams group isn't private. Each Teams group has a Sharepoint site behind where those files are stored. Open that file on the desktop app, go to File > Info > Copy Path. 

    Then, on Power BI, go to Get Data > Web and paste that link erasing the last piece which is something like ?=web1 (the link has to end after the .xlsx) and that's it.