Forum Discussion

Resolver I

4 years ago

Solved

Query loading order

Dear all, assume you've got 2 tables to load from a single SQL database with PowerBI. Each table takes 10 minutes to do so. Via keys the tables are related to each other. While one table is ...

Need Help

v-kelly-msft
4 years ago
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,
Kelly

Did I answer your question? Mark my reply as a solution!

parry2k

Super User

4 years ago

FilipK why not you create a view in the SQL Server and take care of all this at the backend and then use that view in the Power BI.

✨ 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.⚡

FilipK

Resolver I

4 years ago

parry2k , acutally I'm accessing the views. But the views are executed with each query. So output of view 1 holds data from time T, while output of view 2 holds data from T+10. Do you mean, that I shall take that delay already into account and filter the view accordingly?

Forum Discussion

Query loading order

Related content

Query Loading Order

power query editor slow loading

Load multiple tables using query

Impossible to Load: Token Time Out in Power Query

V-Order & Z-Order