Connect Excel to a Power BI data model

This is key for me in leveraging the powerhouse dynamic duo that power BI and Excel create. While I am not aware of any drag and drop method all you need is the data connection (created when the pivot table loads to excel from PBI) and cube functions in your formulas to get to your data outside of the pivot table and pbix file. In all of my complex excel models / reports, I use this method to pull in all the data I need from my PBI models.
Cube functions can look intimidating at first but they are actually very intuitive once you write a few. And with the beauty of excel, you can write one and drag it down the row or column and have it populate the measure or metrics according to different cell variable (each date, product category, etc.) Also, the data connect to the PBI file keeps the excel model / report updated with every refresh.

This article introduced me to cubevalue formula ( way back when PBI was Power Pivot), it’s the function you will use most to pull your data out of your PBI and into excel. The post references PowerPivot, but it’s one in the same for PBI.
https://www.excelcampus.com/cubevalue-formulas/