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!
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).
Community SupportHi 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,
Kelly
Did I answer your question? Mark my reply as a solution!