Sort by field not appearing

Summary

Power BI receives enhanced sorting integration for fields in live connections to databases.

Power BI improves sorting options for live databases

An issue has been identified regarding the sorting of calculated fields in Power BI when using a live connection to databases like Hive/Impala. The problem manifests as the absence of a "sort by field" option in the sorting tab, which does not occur when using extracts.

Why this is important

This issue impacts BI professionals relying on live data sources, particularly in environments where real-time data analysis is crucial. The lack of sorting functionality could diminish the usability of reports, which is a challenge that competing tools like Tableau can address. As organizations increasingly depend on live data, resolving these issues will significantly affect the efficiency and effectiveness of BI tools.

Concrete takeaway

BI professionals should be aware of these limitations in Power BI and proactively test how sorting functionalities work in live connections. This can help them explore alternative solutions or methodologies, such as working with extracts or investigating other tools.