Disabling "Include in Report Refresh": Bug or feature?

[ImkeF]

When disabling "Include in Report Refresh" in a "standalone" query, it behaves as I would expect it: The data will not be refreshed when I refresh the report.

But on the other hand, if I reference this query with another query, these data will be refreshed and passed on to the referencing query. 

I didn't expect this kind of behaviour, so was wondering if this is intended behaviour or a bug that will be removed in the future?

[RoryNBi]

Hi - I'm having the same problem. It's extremely frustrating as we're spending a lot of time loading data from a pretty slow system that we know hasn't changed. Did you find a workaround?

[ImkeF]

No, unfortunately not. Pls vote for this feature!0

[Anonymous]

Is this feature still in development?

[ImkeF]

To my knowledge: Yes (unfortunately)

[JuanAntonioMLE]

Does anyone know where to vote this issue?

I think it is an important thing to fix and it has already been long time.

Thanks!!

[ImkeF]

I once opened an issue here, but was told the current behaviour is by design: https://community.powerbi.com/t5/Issues/Bug-in-quot-Don-t-include-in-Report-Refresh-quot/idi-p/11135...

You might want to give a go yourself and open a new issue, as this is already some years old.

[JuanAntonioMLE]

Thanks for the information ImkeF.

[v-shex-msft]

Hi @ImkeF,

I test on Version: 2.40.4554.463 64-bit (October 2016), but I can't reproduce your issue.

Steps:

Source Table:

Reference this query and disable original table's "Include in Report Refresh".

Save and return to report, modify the source data(excel) and refresh.
Result: The referenced table has been changed, original table not refreshed.

Open the query editor and I find these query not changed.

Use refresh preview button to refresh the reference table, but original table still not changed.

Regards,

Xiaoxin Sheng

[ImkeF]

Thank you!

I've experiencing the same behaviour. The result, that the referencing query is refreshing the data is the issue I'm having with it:

When I freeze my source-table, I would have liked this freezed content to be passed onto the following queries and not the refreshing ones. (At least as long as the incremental load isn't implemented in PBI)

Therefore my question: Bug or feature?

[v-shex-msft]

Hi @ImkeF,

I will report this to Microsoft. (In my opinion, it more like a issue instead of a feature.)

Regards,

Xiaoxin Sheng

[ImkeF]

Thank you very much!

This would be a real game-changer for the workarounds until the incremental load is officially featured, as this is the only way that you can avoid a re-load of huge amounts of dataset that actually will not change anymore.

So I'd be very happy if you could report back if the development team shares our view.

Thx again, Imke