Forum Discussion

ijmiller16's avatar
ijmiller16
Frequent Visitor
7 years ago

Reference Another Query as Source Still Refreshing

Hello,   I might be over complicating this, but I have a large 4GB flat file that I am ingesting into Power BI. I then have another query that references the 4GB ingestion. I'd like the query refer...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi ijmiller16,

 

I'm afraid that is how Power Query works. Creating an independent query won't help in your scenario. Maybe you can try table-buffer function. Please also refer to evaluation-model.

 

 

Best Regards,
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    ijmiller16 

    Did you find a way for the 4Gb source file to only be queried the once and for any downstream queries to reference the cached query, and therefore no need to query the original source file again?