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.
SLICER - SELECT ALL WHEN SEARCHING
For my slicer I have enabled the option to select all, but when i search for something specific the option to select all is not there. Is there an option to add it? without any searching select all appears when i write on search text box i do not have the option to select all
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.
Searching a slicer in my Direct Query report blows it up (ORA-00904)
Good afternoon! Anonymous and I are building a report that performs a Direct Query to an Oracle database with a custom SQL query (that we feel is optimized) through a gateway. We originally had several search boxes with the Text Filter visual added, but when we would search we would immediately lose all the visuals. We replaced this with a slicer. It takes a moment for all the values to load, but when we select one it works. If we attempt to search the slicer at all, we lose the slicer visual with an ORA-00904 (invalid identifier) error. If the slicer has loaded all the selections, is it passing the search through SQL? I assumed it would just search in local memory. Do we need to do something funky to the SQL query? Is this just an optimization issue? Hopefully we're not the only people fighting this. Thanks in advance!
Clear a Search text box in a slicer field
Hi , The search text entered in the slicer won't clear even after hitting eraser OR using book mark to clear default selection . We're seeing this issue on both on Power BI Desktop and Power BI Report Server ( not sure about Power BI Service, because we're using On premise PBI Report server ). Could you please let us know the solution to fix this issue . If this is expected behavior, kindly fix this in upcoming versions . Thanks in advance !Count appearance of string in a comma-separated data column does not count values after the first co
I have two tables: Products table has a single column with one product per field: List table has several columns but the column I'm interested in has fields that can have as little as one product to as much as 17, all separated with a comma and no spaces in between: The issue I'm facing and need help with is to correctly count each product either, ideally as as a measure. I tried two measures but they both gave me an incorrect count of blanks; there are no blank values either table. What I found is that both measures count only the *first* value they find in the List column and then continue counting subsequent rows: How can I correctly count all values in each field from the List table and have zero "blank" counts? Thanks!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.
