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,420 points
463 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,870 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,550 points
91 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
83 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 avantika
• 1,500 points
187 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
121 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
• 32,910 points
211 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,420 points
15,708 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
6,350 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,420 points
129 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,870 points
92 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,870 points
51 views