Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've taken over a report that is a bit complex and contains hundreds of visualizations and a lot of data that I suspect is redundant. By selecting a visualization, I can see in the Data sidepanel, which table(s) (and variable(s)) that visualisation uses. However, is there a way to reverse that, and select a table to find out which visualisations use that table? This is a bit like being able to see dependencies between datasets, but extended to include visuals. I'd like to do this to identify which datasets are redundant without having to click through each visual and write down which dataset(s) it uses.
Ideally I'd have a dependencies diagram that shows connections from source data all the way from source data through to visualisations (at the moment, the final layer is the production datasets, but that doesn't give insight as to whether those datasets are used).
Solved! Go to Solution.
Hi, @rg255
Based on the information you have provided, I can see that you want a tool that removes redundant data and reorganizes it for a clearer visualization. I think you can use yEd Graph Editor to process the data and then get the dependency graph in yED.
1. Exporting data from Desktop.
2. Open the exported file from Desktop in yED.
3. You can do relational mapping and remove data you don't need in yED.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @rg255
Based on the information you have provided, I can see that you want a tool that removes redundant data and reorganizes it for a clearer visualization. I think you can use yEd Graph Editor to process the data and then get the dependency graph in yED.
1. Exporting data from Desktop.
2. Open the exported file from Desktop in yED.
3. You can do relational mapping and remove data you don't need in yED.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @rg255 try to use power bi helper - third party tool
https://powerbihelper.org/
Proud to be a Super User!
Hello @rg255 ,
check the following https://www.brunner.bi/measurekiller
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |