Connect and analyze Power BI data directly from Excel, with the July update of Power BI publisher for Excel

Since its release last March, Analyze in Excel has been warmly welcomed by the Power BI community. It brought new meaning to the term better together that Power BI and Excel are working hard to achieve.

With this month’s release of Power BI publisher for Excel, we’re pleased to announce that Analyze in Excel is now easier than ever, and can be initiated directly from Excel using Power BI publisher. With this release, there’s no need to download .odc files, and no need to manually install OLE DB driver. Just install the latest version of Power BI publisher for Excel, and use Connect to Data from the Power BI ribbon tab in Excel.
 

ec9a0294 a753 4881 991c 1c4b970cbd00 Connect and analyze Power BI data directly from Excel, with the July update of Power BI publisher for Excel


Why should I use Power BI publisher to do Analyze in Excel?

With Power BI publisher for Excel you get a simple and friendly experience, which lets you achieve more with your Excel connection to Power BI:

  • 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

That’s cool! So how do I use it?

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).

44094059 a503 4d2f a9db 355a2811c1c0 Connect and analyze Power BI data directly from Excel, with the July update of Power BI publisher for Excel

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:

ee930ef2 8bbb 4bdd 8375 9d8168334680 Connect and analyze Power BI data directly from Excel, with the July update of Power BI publisher for Excel

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. The connection is live, meaning that each interaction on the Pivot table will initiate a query to Power BI to get fresh data.

Note: Currently, data that was shared with you, but not directly visible to you in Power BI, is not available in the Connect to Data dialog.

SQL Server Analysis Services On-premises source: Datasets in Power BI that originate from SQL Server Analysis Services that reside inside the organization network (‘On-premises”), will be connected to the on-premises source and not through Power BI. This means that the user trying to connect must be on the on-premises network, and also authenticated on the Analysis Services in use.

What if I don’t have any data in Power BI yet?

If you’re new to Power BI and don’t have any data yet, don’t worry! We have a special treat just for you: Power BI publisher for Excel will recognize that you don’t have data, and will suggest that you import available sample data into your Power BI workspace. Once you approve, the sample data will be deployed on your Power BI workspace and a pivot table that is connected to it will be created.

e23f5981 3846 4185 8161 387cc01b3252 Connect and analyze Power BI data directly from Excel, with the July update of Power BI publisher for Excel

This update also includes bug fixes and stability improvements.

Analyze away! And don’t forget to pin your insights to your dashboard when you’re done 44d469f6 1262 4ccf a504 032f1356a1f4 Connect and analyze Power BI data directly from Excel, with the July update of Power BI publisher for Excel

If you want to learn more about Power BI publisher for Excel, you can read our documentation.

As always, feel free to send us your questions or feedback directly to xlpbifdbk@microsoft.com, or use one of the following channels:

This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
Recommended article from FiveFilters.org: Most Labour MPs in the UK Are Revolting.

Microsoft Power BI Blog | Microsoft Power BI