What do "Enable Load" and "Include In Report Refresh" mean/do?

powerbi powerquery
Marc Pincince picture Marc Pincince · Feb 6, 2017 · Viewed 21.4k times · Source

In Power Query, when I right-click on the name of a query (in the left-most pane of Power Query's window) I see selections for "Enable Load" and "Include In Report Refresh."

I cannot find an explanation of what these two selections actually mean and do. I'd definitely appreciate a brief tutorial.

Answer

Eugene picture Eugene · Feb 6, 2017

"Include In Report Refresh" means query is automatically refreshed when you press "Refresh" button on the ribbon.

"Enable Load" means query results are available for report builder. Otherwise you may use it in your other queries (for example to merge data), but it is not shown in the report builder.

Related questions

Difference between PowerPivot, PowerQuery and PowerBI

What is the difference between PowerPivot, PowerQuery and PowerBI? How should one decided which tool should be used and when.

Read More
What's the difference between DAX and Power Query (or M)?

I have been working on Power BI for a while now and I often get confused when I browse through help topics of it. They often refer to the functions and formulas being used as DAX functions or Power Query, …

Read More
How to Do Countifs/Sumifs in PowerQuery M.Language Formulas?

Is it possible to Do Excel's Countifs/Sumifs formulas in powerquery Formulas? Let's Say I have [Column1] as "Criteria range" and [Column2] as "Criteria" (Example criteria [Column2] text contains "Product") and I want Count/Sum [Column1] Cells in the new …

Read More