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
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Lihobday,

 

Did you mean you want to connect to an online Excel located in Sharepoint? Please refer to this documentation. You need to copy the link from the Excel.

 

Best Regards,

Dale

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
    Microsoft 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?