Forum Discussion
Solved
Microsoft optimization suggestion - using a shared query
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, pleas...
Hi jaryszek
Sorry for the delayed reply.
Absoluletly, that would be the right order of query execution.
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
Thank you, so it means that
SyntheticBasePath
will be used only once at the top of other queries? And order will be :
1) calculate shared query
2) put it into memory
3) used by other queries
??
Best,
Jac
Hi jaryszek
Sorry for the delayed reply.
Absoluletly, that would be the right order of query execution.
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
thank you!