Menu
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.
653
The option 'Enable load' can be found by right clicking on the table. Typically, by default, the load is already enabled. There is also an option 'Include in report refresh' which lets a user stop a table from refreshing when they refresh the entire report.
Enable Load means results provided by the query are available for report builder else you may use it in other queries like merging data but it is not shown in the report builder. Include In Report Refresh means query gets refreshed automatically when you press refresh button on the ribbon.
"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.
55
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
