Forum Discussion

SP's avatar
SP
Frequent Visitor
8 years ago
Solved

Link MS Team excel spreadsheet link to

Hi All,   Have a power BI report linked to excel source placed in shared location. The excel is now placed in Microsoft Teams site.I have been provided an url to link teh Power Bi report.   Is t...
Data Modeling
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi SP,

     

    You can get the Excel link in Teams follow this article: 

     

     

    Now you get the link, please remove ?web=1 string at the end of the link as mentioned in the article. 

     

    Open the original report in Power BI desktop, go to Query Editor-> Advanced Editor, modify the source step with below: 

     

    Source = Excel.Workbook(Web.Contents("<URL you got from above steps>"), null, true),

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi SP,

 

You can get the Excel link in Teams follow this article: 

 

 

Now you get the link, please remove ?web=1 string at the end of the link as mentioned in the article. 

 

Open the original report in Power BI desktop, go to Query Editor-> Advanced Editor, modify the source step with below: 

 

Source = Excel.Workbook(Web.Contents("<URL you got from above steps>"), null, true),

 

 

Best Regards,
Qiuyun Yu

SP's avatar
SP
Frequent Visitor
8 years ago

Hi v-qiuyu-msft,

 

Thanks for your response.

But i checked with MS support team and they responded with belwo response:

 

"

As discussed over the call, Microsoft Teams is not a default connector from Power BI desktop , We will be passing this to Product development for feature enhancement. As an Work Around you can use  SharePoint and different SharePoint   connectors are available in Power BI desktop."

 

So i have moved my excel file to SharePoint. But will surely try yoru suggestion as well.

 

 

Thanks,

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi SP,

     

    Yes there indeed isn't a specific Microsoft Team connector in Power BI desktop. But as I suggested before, you can use web data source to get data. 

     

    Best Regards,
    Qiuyun Yu