I just saw the PASS BA Data Preparation in Power BI presentation by @Rad_Reza and i was really impressed with the #shared function.
Just try it out open a blank query and type = #shared
and you will see a list of functions from which you can click the function and see a detailed description along with its parameters. Cool for finding new Power Query M functions.
Or if you prefer simply in advanced editor cut and paste over existing text the following
letSource = #sharedinSource
see more after time 39:26 here
Hey guys....If you find this useful give it some kudos or a like.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.