"Refresh failed due to gateway configuration issues" - "include on report refresh" is disabled

[Anonymous]

Hi,

I currently have a desktop model which is connected to a mix of sharepoint files and our data warehouse. I do not yet have a gateway establsised for the datawarehouse tables so I have disabled these tables from being refreshed during a report refresh. Despite this when I try to refresh the report in service I am getting the gateway error. Is this an oversight from the powerbi developers or is there something else I need to disable?

thanks. 

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

Disable "Include in report refresh" feature is only works in power bi desktop, in power bi service, it does not work. So the table still refresh, therefore, you need a gateway for it to refresh.

https://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-report-refresh-quot-not-working/td-p/432771

Regards,

Lin

[pattersonm8]

so what is the recommendation for a data set you loaded once and no longer there but want to keep that history, the disabling "include on report refresh" works perfect in app, but now my scheduled refreshes fail because still tries to look and have to do manal each day

[Anonymous]

Dissapointing setup but thank you for the answer. 

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".