Forum Discussion
Resolver IQuery loading order
Hi FilipK ，
Try to shape data at the query editor before you load them:
You could create a new table keeping the transformed data.Then choose uncheck "Enable loaded" for the oringinal table.
For the reference,pls see below:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
Super UserFilipK yes, why not have that heavy lifting done at the backend.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Resolver IPerhaps I don't understand your point in total. If needed I can do in backend. No problem. But I'd like to avoid working with constant times, since the time for refresh is not constant (depending on SQL performance at that time and other database workloads).
- v-kelly-msft
Community Support
Hi FilipK ，
Try to shape data at the query editor before you load them:
You could create a new table keeping the transformed data.Then choose uncheck "Enable loaded" for the oringinal table.
For the reference,pls see below:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!