Power Community

Power Community

Analyze in Excel Workbooks are now saved to OneDrive for Business

We’re excited that over the coming weeks, you will see us improve the Analyze in Excel experience in the Power BI service. By making these changes, we’re eliminating steps and making it easier to open the saved Excel workbook.

What is the current experience and why do we need to make a change? 

Today, when you click the Analyze in Excel button on a Power BI dataset or report, the generated Excel workbook is downloaded to your local Downloads folder. However, opening the file won’t work unless the user has the Analysis Services OLE DB Provider installed. Power BI prompts the user to install the provider, but many users don’t install it or don’t open the file.

How the new experience improves the Analyze to Excel workflow

With this new experience, the Excel workbook created through Analyze in Excel is saved to your OneDrive for Business. The workbook opens in Excel for the web by default.

Open Analyze in Excel workbook in Excel for the web.

After clicking Analyze in Excel, a new dialog indicates the generated workbook was saved to OneDrive. Clicking on Open in Excel for the web opens a new browser tab that enables you immediately to create PivotTables on your Power BI dataset.

You can also open the workbook in the Excel Desktop. Just click Open in Desktop App in the Excel for the web ribbon.

Open Excel workbook in the Excel Desktop app from the browser.

Best of all, with this new experience, you don’t need to install the Analysis Services OLE DB Provider on your computer before using Analyze in Excel.

If you have any suggestions on improvements or new features you would like to see for Power BI and Excel, please submit an idea.

- Advertisement -spot_img


Please enter your comment!
Please enter your name here

- Advertisement -spot_img

Latest News

Microsoft Power Apps Portals Bootcamp & Hackathon

From Thu 25th August To Sat 27th AugustGo to the event
- Advertisement -spot_img

More Articles Like This

- Advertisement -spot_img