Embed a dashboard into an Excel that is shared in Sharepoint

[OvidiuNeacsu]

Hello everyone, 

I have an Excel file that is in SharePoint, shared between multiple departments in the company. I need to update it every week with a simple calculation. 

What I would like to achieve is embed the dashboard/app/metric that contains exactly what's needed into that Excel Sheet.

I tried Get Data (but it's not present) 

In Options, I've read that there's a Power BI add-in, which is not present in SharePoint. 

Any ideas on how I can get 1 metric into this excel without doing it manually every week? 

Thank you very much for your support, 

Ovidiu

[OvidiuNeacsu · Accepted solution]

Solved it. I was supposed to open the file from Desktop to have those options. Apologies. 

[Syndicate_Admin]

@Caesar , is the metric coming in as a single string, value or some other object? Does it have a specific destination like at the end of a table or target range?