Microsoft optimization suggestion - using a shared query

[jaryszek]

Hi Guys,

this is the asnwer which i got from microsoft to use python query approach in power bi:

2. If you still prefer to use Python to retrieve the value of the environment variable, please create a shared query for each environment variable and then reference this shared query in all other queries.

 

Step1: Create a shared query (e.g. SyntheticBasePath)

let

    path = fnGetPath(ParamCostMgmtSyntheticPath)

in

    path

Step2: Reference SyntheticBasePath in other queries

 

let

    Source = Csv.Document(

        File.Contents(SyntheticBasePath & "BudgetFact.csv"),

        [Delimiter = ",", Columns = 12, Encoding = 1252, QuoteStyle = QuoteStyle.None]

    )

in

    Source

cam anybody explain how this is working and why this is better approach?

Best,
Jacek