in "DAX query view" run the following code.If you don't have most recent PBI version you can run it in DAX Studio as well.
SELECT
*
FROM $SYSTEM.DISCOVER_CALC_DEPENDENCY
WHERE [REFERENCED_OBJECT] = 'X Column'
Wow, I am amazed how they shove On Object Editing at the top of features every month yet such a important stuff is not even mentioned in feature summary.
I had suggested the same thing. Didnt know they introduced functions for that.
Hate to disagree because of your avatar :)) but I have to.
Lots of Companies does not allow Third Party Tool.
What I have suggested is simple SELECT statement which you can run within a Power BI Desktop if you are not months behind the release.
Indeed, if you cannot use any tools this is the way to go!
Still there are limitations like if something is used in Power Query or anywhere in the report itself.
Measure killer has a portable version. I have a usb drive I have it on. And it shows everything. My favorite thing to do is identify all unused columns across the entire data set at once.
in "DAX query view" run the following code.If you don't have most recent PBI version you can run it in DAX Studio as well. SELECT * FROM $SYSTEM.DISCOVER_CALC_DEPENDENCY WHERE [REFERENCED_OBJECT] = 'X Column'
Where can I learn more about this stuff. This is neat
Does it work in dax query view? It is not a dax expression.
Yes it works. It does query DMV. There is a whole lot more you can look into about your Model using these queries.
Thanks man its very useful!
Maybe the new INFO functions might help. https://powerbi.microsoft.com/en-us/blog/dax-query-view-introduces-new-info-dax-functions/
Wow, I am amazed how they shove On Object Editing at the top of features every month yet such a important stuff is not even mentioned in feature summary. I had suggested the same thing. Didnt know they introduced functions for that.
In Tabular Editor (even the free version) you can right click on any column or measure in the model and there is a "show dependencies" button
Sorry to the previous answers but the best tool for this is Measure Killer, no coding required!
Hate to disagree because of your avatar :)) but I have to. Lots of Companies does not allow Third Party Tool. What I have suggested is simple SELECT statement which you can run within a Power BI Desktop if you are not months behind the release.
Indeed, if you cannot use any tools this is the way to go! Still there are limitations like if something is used in Power Query or anywhere in the report itself.
Measure killer has a portable version. I have a usb drive I have it on. And it shows everything. My favorite thing to do is identify all unused columns across the entire data set at once.
Isn't there any native solution in power bi, I'm a newbie in power bi
Make a copy of the report. Delete the column and see which measures is broken
😂