Connect PowerBi to excel sheet

[Clarab9]

Hi All,

I am currently trying to self teach in the use of PowerBI, i have hit a road block when trying to pull in live data from a PBI report into an excel sheet.

Once i have created the connection, the raw data i pull in i would then like to populate certain cells, i am sure this can be done, but i am unsure of the process steps needed to complete these two steps.

If i could describe it - The data i pull in from powerbi i will use to populate certain metrics, so each week when i verify the data it removes the need for myself to manual type in the data.

Any assistance would be appreciated in helping me build my capability thank you

 

[Matt Allington]

I assume you have published the Power BI report to PowerBI.com
I also assume you the. Created an Analyze in Excel workbook connected to the report
You should then build a pivot table containing your measures in the excel workbook
Then, in Excel, select the pivot table, goto pivot table tools menu, olap tools, convert to formulas. This will turn each number in the pivot table to a formula. From there you can copy the formula to the cell you want