Forum Discussion
Impactful IndividualReferencing vs duplicating queries speed affect
Hi masplin
I would suggest using the second way.
As for the first way, you have to import this source four times totally even if you removed unnecessary columns. It is inefficient. If your source contains amount of data, it will take some time whether it is importing or refreshing.
Super UserI did not get it completely. But if you want to analyze data by three different dates. You can join all three with date dimension with one active and two inactive and you can use userelation to activate the relation
If you are not looking for this then, Can you share sample data and sample out. If possible please share a sample pbix file after removing sensitive information.Thanks.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Decoding Direct Query - Time Intelligence
Winner Coloring on MAP ,
HR Analytics
Power BI Working with Non-Standard TimeAnd
Comparing Data Across Date Ranges
Connect on Linkedin
Impactful Individualsorry the question is does referencing reduce the number of times the data is recovered to just once, whereas repeating the query results in multiple calls for the same data? Potentially the multi queries ot same data does not actually result in another cal las the dat is cached.