Forum Discussion
Solved
Using Source of one query for another
Hello I have a .pbix file, where we import few views and tables(Oracle). In some queries, the view imported are same but steps are different. Example : 4 queries imports same view and then has diff...
Yes, absolutely.
- Do your initial import of the view and any transformations you want. You don't have to do any, but you might want everything to be filtered for the last 2 years for example. Do that here so you don't have do that 4 times in the next step.
- Right-click on that query and select REFERENCE. That will make query 1 the source of query 2. Any changes to 1 will affect 2 (and 3, 4, 5.)
Do not select DUPLICATE. That will copy the first query and changes made in 1 will no longer affect 2. You might want that for other scenarios, but it doesn't sound like you do for this question.
In the ci=onnection you have an advance option where you can write down query.