This month Microsoft has released a new feature to power BI. We can connect an Excel File directly to PowerBI and using pivot table to analyze DataModel.
What We need?
- PowerBi Account Pro ( use the trial) , the same used on excel
- Excel 2013-2016
- An Existing datamodel on powerbi ( i use a powerbi desktop model on powerbi)
- SQL_AS_OLEDB feature: you cand find on this Link32bit or link64bit
How to Connect?
Go to powerbi site and select one of your datamodel or report :
Click on Analyse in Excel. PowerBi create a ODC file in automatic and download it on your computer.
Open your excel and go on data tab, select existing connection,:
Click on browse in le left corner and select the connection created by power bi. After that create a pivot table and you have completed alle the operation.
Congratulation now you can use your PowerBI model on your excel!