Hey, I am into Excel now, Power BI

Since “Analyze in Excel” was released by Microsoft in March and it has have been greeted well by the Power BI community and its partners. It brought new meaning to the term best together that Power BI and Excel are working hard to acquire.

Power BI Toolkit

Microsoft is pleased to announce that Analyze in Excel is now easier and faster than ever, with Power BI for Excel. With this update, there’s no need to download .odc files and manually install the OLE DB driver. To apply Connect to Data from the Power BI ribbon tab in Excel, deploy the updated version of Power BI publisher for Excel.


  It would be best if you used Power BI publisher to do Analyze in Excel because: 

You get an effortless and user-friendly interface, which lets you attain more with your Excel connection to Power BI:

  • With this latest release, you are not required to install the AS OLE DB drivers and keep them updated manually; they are built-in with this update.
  • Power BI publisher generates the connection and the pivot table automatically, which means you don’t require to download .odc files to produce the connections and pivot tables;
  • By using a more comfortable way that is intuitive dialog in Excel, you can now export the report or the dataset
  • You can generate various connections and pivot tables in the same workbook.

Sounds Cool, right? Experience it!

Install the Power BI publisher for Excel; you’ll need to sign in to Power BI first and then open Excel and go to the Power BI ribbon tab, click Connect to Data.


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

After you select the workspace and dataset, click the Connect button, and there you go! You’re all set to analyze with a pivot table connected to your data in Power BI. The connection is live, which means that each interaction on the Pivot table will commence a query to Power BI to get fresh and new information or data.


Note: Currently, the data shared with you, but not directly seen by you in Power BI, is not obtainable in the Connect to Data dialog.

What if you are new to Power BI?

You’re new to Power BI and don’t have any information yet, don’t worry! Microsoft got you covered: Power BI publisher for Excel will perceive that you don’t have info and ask you to insert available dummy data into your Power BI workspace. Once you grant the dummy information, it will be deployed on your Power BI database, and a pivot table that is attached to it will be generated.

For additional education on Analyze in Excel, contact Microsoft’s best-managed service providers.

New to Power BI? Get it today at our exclusive online store.


Share This Post

481 Main St #100, New Rochelle, NY 10801, United States



Privacy & Cookies Policy