What do Enable Load and Include In Report Refresh mean do

0 votes
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.
Dec 21, 2020 in Power BI by Roshni
• 10,480 points
2,001 views

1 answer to this question.

0 votes

"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.

answered Dec 21, 2020 by Gitika
• 65,950 points

Related Questions In Power BI

0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,570 points
148 views
0 votes
1 answer

Append excel data and In house database data that gets refresh evey 24 hour

Hi, You can try this way, A  -  Actual ...READ MORE

answered Mar 20, 2019 in Power BI by Sindhu
138 views
0 votes
1 answer

How do you schedule Data Refresh in Power BI?

Hi, Following could be the reasons why this ...READ MORE

answered May 21, 2019 in Power BI by EdurekaUser
• 1,500 points
284 views
+1 vote
0 answers

store images from a power publish report in db and call those images

Hi Experts What is the best way to ...READ MORE

Jul 3, 2019 in Power BI by Parminder
• 130 points
177 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,010 points
280 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
27,980 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
10,033 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4, 2020 in Power BI by Roshni
• 10,480 points
175 views
0 votes
1 answer

How do you Hide and Unhide a Specific Report in Power BI?

In the menu bar, choose the Selection ...READ MORE

answered Oct 20, 2020 in Power BI by Gitika
• 65,950 points
502 views
0 votes
1 answer

How to Toggle Between Two Option and Make it Interact with the rest of the Visualizations in a Report?

Toggling is an action that is achieved ...READ MORE

answered Oct 20, 2020 in Power BI by anonymous
• 65,950 points
112 views