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