cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chriswragge Regular Visitor
Regular Visitor

Optimal Setup for "Include in Report Refresh"

Hi there,

 

I am wondering the optimal setup for the "Include in Report Refresh" feature.

 

For example: I have queries pulling from an third party API that I use for Vendor reporting. These create Table A and Table B. I then manipulate Table A and B seperately, before appending Table A to Table B (using the Query Editor) into a new query - Table C, which I load into my data model.

 

 

I feel like I have 4 options:

  1. Enable "Include in Report Refresh" (IRR) for Tables A, B and C
  2. Enable IRR for Tables A and B only
  3. Enable IRR for Table C only
  4. Do away with creating Table C using the Query Editor, and do so via DAX. Then enable IRR for Tables A and B

 

Option 1

I think runs hits the API 4x in total. Once each for Tables A and B (desired behavior), and then twice again for Table C (undesired behvior). Not sure if this bug on Microsofts part, or intended functionality. See link - https://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-Report-Refresh-quot-Bug-or-featur...

 

Option 2

This looks to be a good option, but I am unsure if Table C gets updated with the new data if I disable it's IRR functionality

 

Option 3

I think this hits the API twice, but runs the queries sequentially and thereby increasing the total query time. It would be great to run Query A and B.

 

Query 4

A backup option for option 2. The downside of this is the DAX can get kind of messy I decide to perform transformations other than a UNION. Plus, it adds bloat to my data model as I need to enable load for A, B plus the DAX Table C

 

Can anyone shed light on these hypotheses and point me to towards the optimal setup?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Optimal Setup for "Include in Report Refresh"

HI,@chriswragge 

     "Include in report refresh" option only works for Power BI Desktop, it doesn't impact the refresh process in Power BI Service.

In Power BI Desktop, when  you disable "Include in report refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop.

For example

IF you enable IRR for Tables A and B only

then after you click "Refresh" button in Desktop,table A and B will refresh but table C will not refresh.

IF you enable IRR for Tables C

then after you click "Refresh" button in Desktop,table A and B will not refresh but table C will refresh.

 

Best Regards,

Lin

   

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
chriswragge Regular Visitor
Regular Visitor

Re: Optimal Setup for "Include in Report Refresh"

Apologies - I should have been clearer. The API I was referring to was the an external API (the Adobe Analytics API), and not PowerBI's API