cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Essentially a "Paste Values" the final result of a long, complicated query.

I'm curious if there's a way to essentially "Paste Values" the final result of a query.  The excel analogy would be a long string of iferror vlookups that finally lead you to your looked up value.  And then once you have it, you don't need to do the lookup formulas anymore.  You just paste values over the formulas and reference the pasted value so your model is not bloated.  You just needed it that once.

 

I have a similar issue with a Power BI model where I have a daisy chain of merge queries because the ID value I needed is housed in several different, unconnected, large data sets (....yeah...fun....).   Then once I find that ID, the actual substance of the report takes place.  I only need to run that daisy chain of merge queries once a month.  Then for the rest of the month I use that ID for it's own query work.  But everytime I point to that ID for something, it requires a load of all the query work that got me that ID (which is looooong and inefficient).  Even though I have "Include in Report Refresh" and "Enable Load" disabled.  To be clear, I need this ID in the query editor, not just built into relationships afterwards.

 

Unfortunately the dataset is in the millions of rows so exporting it as CSV and re-importing it into a new Table seems impractical.  I just want to be able to use this ID field and have the query work before stop trying to load up (except the once a month when I refresh it).  

 

Ideas?

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Essentially a "Paste Values" the final result of a long, complicated query.

Hi @kurtbarajas ,

I am confused about your requirement. If you want to replace the values , you could try creating parameters. If not, please post some data and the expected results that we will understand your actual scenario clearly.

How to Get Your Question Answered Quickly

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Essentially a "Paste Values" the final result of a long, complicated query.

@v-xuding-msft  Let me try to explain it another way.  I have a calculated column that has dependent queries that I don't want to refresh (because it takes too long).  But when I reference that calculated column, it automatically refreshes dependent queries (unchecking "disable load" and "include in report refresh" doesn't work for this).  So I'm looking for a way to either not refresh dependent queries, or just abandon the dependent queries altogether and "paste" the values of the calculated column.

 

I can try to bring in a dataset but it's conceptually irrelevant to the issue I'm having.  It could be any caculated column that relies on dependent queries.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors