Integrated Dependency Search in Power BI
Many of us working with complex data models in Power BI fear breaking our dashboards when modifying or deleting columns. While Power BI offers ways to analyze dependencies, such as INFO.CALCDEPENDENCY() and tools like Power BI Documenter, can be cumbersome for quick use. Wouldn't it be beneficial to have a built-in, intuitive search option that allows users to quickly find where a specific column or measure is being used across visualizations and other elements? This feature would help ensure that any changes made to the data model won't unintentionally disrupt reports, making Power BI even more robust for developers handling large datasets. By building on existing features but enhancing usability, could save time and reduce errors for Power BI users. So let's set up that as a Feature Proposal: Problem Power BI users often struggle to understand the dependencies between data models, visualizations, and measures, leading to accidental modifications that can break existing dashboards. Solution Implement a search function that allows users to quickly identify visualizations and measures that use a specific column. This will help users: Reduce the risk of errors by understanding potential impacts before making changes. Improve efficiency by streamlining the process of finding relevant visualizations and measures. Enhance data governance by providing better visibility into how data is used. Proposed Features: Advanced Search Options: Search by column name, data type, or specific conditions (e.g., "visualizations that use the 'Sales Amount' column and have a total sum"). Visualization Preview: Provide a preview of the visualizations that match the search criteria to help users quickly identify relevant results. Dependency Graph: Visualize dependencies between columns, measures, and visualizations using a graph or network diagram. Impact Analysis: Offer a tool that can assess the potential impact of changes to a column or measure, highlighting which visualizations and measures might be affected. Benefits Improved Data Quality: Reduced errors and increased efficiency can lead to better data quality and accuracy. Enhanced Productivity: By saving time and effort, users can focus on more strategic tasks. Better Data Governance: A clearer understanding of data dependencies can support better data governance practices. Stories from Team Imagine a scenario where a Power BI developer accidentally deletes a crucial column, leading to widespread errors in multiple dashboards. This developer could have avoided this issue if they had a tool to identify which visualizations and measures relied on that column. By implementing a column-based search function, Power BI can empower users to make informed decisions and avoid costly mistakes. I encourage the Power BI team to consider implementing this feature to enhance the user experience and improve the overall quality of Power BI reports. If you support this idea, please share your comments and experiences below.
Integrate Full Text indexing in Slicer search
One of the few bad user experiences with our Power BI Report dashboards generated from Microsoft AS Tablular databases is searching by name or code in a slicer when the source table is large. It can take several seconds for the results to come back, which is not bad in isolation but can be very frustrating for someone who is repeatedly selecting from the list. For these cases it would be helpful to enable the slicer to use a full text index search a combined name/code field.
Use Global Search to Find Reports by Page Name
I have had multiple users ask if they can find a report by the page name. I promote using global search, but there are times when someone knows the name of the page, but not the report or workspace the page is in. I think it would be great for early adoption and usability.Searchable Filters in Right Panel
For reports that contain many filters, it would be nice to have the ability to search the list of available filters. Top level filter searching would search all filters (This Page, All Pages, this Visual). Then at each level (This Page, All Pages, This Visual) there will be an ability to search those filters. Default functionality would be down arrow / collapsed for all. When user clicks the down arrow, it turns into an up arrow, and reveals the listing of all filters in a fixed height scrollable window, with search panel, check boxes, and eraser to clear search.
