Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 different steps.
Is there any possibility to import that view in one query, and this imported view can be used as a source for other queries within pbix file? This will help me in avoiding unnecessary 4 imports of same view and have one import of view and use the same as source for other queries.
please suggest.
Thanks
Vignesh
Solved! Go to Solution.
Yes, absolutely.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIn the ci=onnection you have an advance option where you can write down query.
Yes, absolutely.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @edhans
Thanks for your response. yes I tried with Reference already. When I refresh the refrenced query, there is always 2 sessions coming to DB. One from Actual query and other from referenced query. So I was confused, if it's being effective. Also my .pbix file is 1.8Gb and with this reference(common View Queries), my .pbix grew to 2.4 GB. Thats again a problem for me.
It is effective.
A few things:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHI @edhans , @amitchandak
I adapted my report again with Reference and disabled the load.
I see the performance has increased, but I can check on Monday morning. I will keep you posted.
Thanks a lot for your help!
Hi @vikkidurai91 ,
as far as I know, you should deactivate parallel loading in the options so that the queries uses the cache.
There are good contributions from Chris Webb.
https://blog.crossjoin.co.uk/2016/11/20/referenced-queries-and-caching-in-power-bi-and-power-query/
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
@edhans Thanks for your suggestion. We tested for last 2 days and Reference feature has solved the issue.
Thanks all for the help.
Excellent @vikkidurai91 . Glad my suggestion helped and it is helping your project move forward!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks @edhans . I will check this and will let you know. Referencing is a very good option.
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |