Forum Discussion

Lihobday's avatar
Lihobday
Frequent Visitor
8 years ago
Solved

Create BI auto refresh with excel data from MS Teams

How can we connect data from PowerBI online to a MS teams website. Sharepoint is located within a company secure enviroment. I would copy the link from excel online in the http bar and add into "Ent...
Need Help
Lihobday's avatar
Lihobday
Frequent Visitor
8 years ago
Thanks. Perhaps i should clarify. I actually know how to connect it already using O365 or sharepoint in desktop version. But from the power BI web version, how do i connect the excel data from sharepoint to the web version? Reason is because i want to have the data refreshed in every instant where there is a change or update in raw data. I understand desktop version has to be refreshed manually and not automatically.
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Lihobday,

 

1. You can publish the Desktop file to the Service.

2. You can try Get data -> File -> Sharepoint Team sites.

Create_BI_auto_refresh_with_excel_data_from_MS_Teams

 

 

Best Regards,

Dale

  • Lihobday's avatar
    Lihobday
    Frequent Visitor
    8 years ago

    Thanks. I know how to do that but what should the link be? I seem to get an error msg when i copy the link over via teams or MS Sharepoint. Should i be removing some text from the http links?