Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

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.

1 Answer

0 votes
by (47.2k points)

Enable Load means results provided by the query are available for report builder else we 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 we press refresh button on the ribbon.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories