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 PowerBI.com, 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.
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.