Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Without having to open each query in turn (I am tasked with finding out which of the input fields are actually used in Power BI - i.e. which get past the dataflow into the dataset and then is it used in a visual or a measure)
Solved! Go to Solution.
Hi @RichHead1821 ,
Get yourself a copy of DAX Studio from here:
Then get a copy of @ImkeF 's brilliant cleaning tool and all the details on how to use it here:
https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/
I use this all the time and it does exactly what you need it to do, plus a whole lot more!
Pete
Proud to be a Datanaut!
Whilst I didn't get a solution, I've marked it as such to stop the 'nagging emails' 🙂
You could try this one from RADACAD...
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Thanks @BA_Pete - tried that and the cleaner tool fails (column report file(s) not found) - so not a solution for me 😞
That's a shame. Did you match up the DAX Studio and Cleaner versions correctly?
I use Cleaner v10 and DAX Studio 2.15.0 and it works fine. You can pick up older DS versions on their download page and I can put Cleaner v10 on here if you're interested to give it a shot?
I don't know of any other way to do what you want I'm afraid.
Pete
Proud to be a Datanaut!
Hi @RichHead1821 ,
Cleaner v10 attached below.
Pete
Proud to be a Datanaut!
@RichHead1821 - I was under the impression that you can connect directly to the PBIX file if you have it open. (I haven't used it for a while)
Thus avoiding the need for PPU. But if you can use this to get a PPU license then I'd say that's a win. 😁
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Maybe I am misunderstanding the tool, my PBIX files are (in most cases) live connections to datasets, in turn fed from a dataflow, I didn't see any way of seeing the dataflow's power queries when connected to a PBIX file.
I feel like I need to do some reading, but the project timeline won't allow me to pause
Yes that does complicate things some. I'll try and have a look tomorrow if I have time.
I use the same architecture as you're describing.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
I don't think the live connection thing should matter (although I could easily be wrong) as both tools work on either an open or loaded data model. Neither, I believe, go as far as to interrogate sources, just what's available/loaded in the front-end model.
Pete
Proud to be a Datanaut!
I'm not sure, I'll try again tomorrow, at the moment I am manually trawling through it all
Hi @RichHead1821 ,
Get yourself a copy of DAX Studio from here:
Then get a copy of @ImkeF 's brilliant cleaning tool and all the details on how to use it here:
https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/
I use this all the time and it does exactly what you need it to do, plus a whole lot more!
Pete
Proud to be a Datanaut!