Hi,
I'm creating a DevOps dashboard (yes included report functions do not suffice) and seem to need to create a proper starschema. Therefore I'm downloading a "Stories - Weekly" and a "Features - Weekly" Analytics view. These I'd like to combine to create the model. Both will receive a weekly snapshot of the status.
For performance, I'm thinking it's best to load as little data as possible. Right? So first choice:
1. Load both query's as a base for the fact. Then reference the query, filter to obtain the Story and Feature dimension?
2. Load both query's as a base. Then duplicate the query, filter to obtain the Story and Feature dimension. (To me the least likely)
3. Load both query's as a base. Then create a seperate query to an analytics view which only receives the dimension data.
My thinking with reference would be that Power BI would only demand the data once, then needs computation to filter. The duplicate and seperate query option would demand more data. Whereas the seperate query would not need the computation of the reference option. Basically the optimum choice would be 1 or 3. If referencing still results in the query executing multiple times, option 3 would be best.
What do you think?
