filmov
tv
Reference Query in Power Query - Power BI
Показать описание
Referencing a Query
By Referencing a Query, you can create a link between a new query and an existing query. This allows the data to flow in sequential models. Any change in the original query will be reflected in the referenced query.
Reference is another way of copying a query, However, the big difference is that; When you reference a query, the new query will have only one step: sourcing from the original query. A referenced query, will not have the applied steps of the original query. Let’s see this option in action. Continuing the example above; let’s say we want to create a new query that is the result of combining the page 1 and page 2 result. However, we do NOT want to change any of the existing queries, because we want to use those as the source for other operations.
Characteristics of a Referenced Query
• Reference query is directly linked to its parent query. Any changes in parent query directly impacts the referenced query.
• Reference queries cannot be used extensively as they can result in looping or circular references.
• Changing the source directly effects the referenced query because it is dependent on the source used in parent query.
• Referencing a query does not create an independent object. References act as pointers in memory.
• Reference is a good choice, when you want to branch a query into different pathes. One path that follows a number of steps, and another that follows a different steps, and both are sharing some steps in the original query.
Limitation of the Reference
You can not use referenced queries in all situations. As an example; If you have a Query 1, and then you created a reference from that as Query 2. You cannot use the result from Query 2 in Query 1! It will create a circular reference. You are combining a query with a reference to the query itself, It is impossible!
Please Subscribe the Channel for Updates on new Tutorial videos
Practice Files Link
Books
WhatsApp
Blog
Business/Consulting/Corporate /Individual Training
By Referencing a Query, you can create a link between a new query and an existing query. This allows the data to flow in sequential models. Any change in the original query will be reflected in the referenced query.
Reference is another way of copying a query, However, the big difference is that; When you reference a query, the new query will have only one step: sourcing from the original query. A referenced query, will not have the applied steps of the original query. Let’s see this option in action. Continuing the example above; let’s say we want to create a new query that is the result of combining the page 1 and page 2 result. However, we do NOT want to change any of the existing queries, because we want to use those as the source for other operations.
Characteristics of a Referenced Query
• Reference query is directly linked to its parent query. Any changes in parent query directly impacts the referenced query.
• Reference queries cannot be used extensively as they can result in looping or circular references.
• Changing the source directly effects the referenced query because it is dependent on the source used in parent query.
• Referencing a query does not create an independent object. References act as pointers in memory.
• Reference is a good choice, when you want to branch a query into different pathes. One path that follows a number of steps, and another that follows a different steps, and both are sharing some steps in the original query.
Limitation of the Reference
You can not use referenced queries in all situations. As an example; If you have a Query 1, and then you created a reference from that as Query 2. You cannot use the result from Query 2 in Query 1! It will create a circular reference. You are combining a query with a reference to the query itself, It is impossible!
Please Subscribe the Channel for Updates on new Tutorial videos
Practice Files Link
Books
Blog
Business/Consulting/Corporate /Individual Training
0:04:26
0:04:50
0:18:57
0:05:20
0:13:17
0:03:29
0:06:04
0:08:33
3:00:23
0:10:27
0:09:46
0:04:31
0:00:29
0:05:28
0:05:23
0:14:24
0:05:22
0:07:24
0:06:56
0:04:22
0:14:15
0:11:49
0:06:47
0:05:14