Analyze Power BI data directly from Excel

Since its release last march, it’s possible to analyze Power BI from excel. Now Microsoft had added a new feature that brought new meaning to the term better together that Power BI and Excel are working hard to achieve.

How change the Use of Excel on power bi?

With Power BI publisher for Excel you :

  • No need to install the AS OLE DB drivers and keep them updated manually; with this latest release they are built in with Power BI publisher for Excel, and automatically updated with Power BI publisher’s updates
  • No need to download .odc files to create the connections and pivot tables; Power BI publisher creates the connection and the pivot table automatically. All you have to do is pick the report or the dataset, using a simple, intuitive dialog in Excel
  • Create multiple connections and pivot tables in the same workbook

After installing the July update of Power BI publisher for Excel, open Excel and go to the Power BI ribbon tab. Click Connect to Data (you’ll need to sign in to Power BI first).

clip_image002

You’ll see the following dialog, which lets you select the source data to connect to in Power BI. You can connect to Power BI reports or datasets:

clip_image003

After you select the workspace, and the report or dataset, just press the Connect button and that’s it! You’re ready to analyze with a pivot table connected to your data in Power BI.

Annunci

Rispondi

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

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. 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 )

Google+ photo

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

Connessione a %s...