Veteran Excel users like myself, who use filtering and sorting in the data view of Power Pivot, were surprised and disappointed to find that Power BI lacked this capability. Early on I would build and debug a model in Power Pivot and would then import the Excel file to Power BI (this also allowed me to set a date table, another missing Power BI feature that has since been added).

Lately I have been building models in Power BI, but many times have been forced to use Excel to debug and validate the data. Finally, with the June release of Power BI, we no longer need to resort to using Excel, making Power BI Desktop much more productive.

Above: A Power BI Desktop screen showing the tool’s new sorting capability.

Contact us to learn more about how Power BI solutions for Acumatica and Microsoft Dynamics can help your business.