Connect Excel To Power BI

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?

  1. PowerBi Account Pro ( use the trial) , the same used on excel
  2. Excel 2013-2016
  3. An Existing datamodel on powerbi ( i use a powerbi desktop model on powerbi)
  4. 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 :

Immagine 018.png

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,:

Immagine 019.png

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!

 

 

 

Un pensiero su “Connect Excel To Power BI

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo di WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione /  Modifica )

Google photo

Stai commentando usando il tuo account Google. Chiudi sessione /  Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione /  Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione /  Modifica )

Connessione a %s...