Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to discover and display all the Power BI Power Query Mash-up Functions and their definitions and usage
Open a blank Power Bi Desktop
In the External Data group of the Home tab, click on Get Data drop-down
Select Blank Query
In the formula bar, execute the formula: =#shared
Click Enter
To see the definition, function syntax and examples, double-click on click on the Function