load to worksheet failed

[BORUCH]

hi all for some reason whenever i refresh all on my power pivot /power query i get this error can someone tell me please how to fix it

 

[RoryA]

Right-click it in the Queries and Connections task pane in Excel, and choose Load To... then Connection only.

 

[BORUCH]

Right-click it in the Queries and Connections task pane in Excel, and choose Load To... then Connection only.

The problem with doing that is if I uncheck the "add this data to the data model" and just check the "only create connection" it gives me a warning "this query is currently connected to tables,pivot tables,charts,or calculations in your workbook. Removing it from the data model,or changing its loading destination will disconnect these objects from the query.
Disconnected tables and pivot tables might be deleted.
Do you want to continue?"
What should I press here is this a concern ?

 

[RoryA]

I didn’t say anything about the data model option.

 

[BORUCH]

I didn’t say anything about the data model option.

ok so what do i do in this case should i just delete that query ? it seems useless I'm not using it in any reports I'm only using the last query with 7.7 mil rows

 

[RoryA]

No, just change the load to settings so it’s connection only rather than table.

It’s being used as the default value for your parameter

 

[BORUCH]

No, just change the load to settings so it’s connection only rather than table.

It’s being used as the default value for your parameter

it already set up as connection only, the problem is its also connected to the power pivot data model my question is should i unconnected it from there ? I'm assuming if i do that it will work

 

[RoryA]

Is it not working now? It appears to be in that picture

 

[BORUCH]

Is it not working now? It appears to be in that picture

yes that picture is before i refresh once i refresh i get the error

 

[RoryA]

Thinking about it, that should not be loading to the data model. It would serve no purpose there.