Microsoft Power BI Offers “Analyze in Excel”

It used to be the case that models in Microsoft Power BI could be built from Excel files, but the opposite was not possible. This meant users could not define datasets in Power BI and then analyze them back in Excel. Happily, Microsoft recently addressed this limitation.

Now, once a model has been published to, users can select an option called “Analyze in Excel” to connect to that hosted model back in Excel, facilitating the familiar slice and dice functionality of pivot tables.

Senturus Upcoming Events

For more insights on Power BI, watch our on-demand webinar: Microsoft BI: The Right Tools for the Job, where we examine the changes to Microsoft’s BI tools, comparing them to each other and exploring when it’s appropriate to use one versus another.

Comparison Chart of Microsoft Data & Analytics Technologies

Connect with Senturus

Sign up to be notified about our upcoming events

Back to top