datasource.error: analysisservices: the connection is not open.

[o59393]

Hi all

I am getting the following message when I refresh my queries connected to a SQL Server Analysis Services Database:

Also a recurrent message is the following for my append table of 2 queries:

My memory looks like this:

What can I do ?

Thanks

[o59393]

Hi @amitchandak 

I cleared the permissions but same error:

Regards.

[amitchandak]

@o59393 , I think this connection issue. Edit data  source clear premission and try again. Also able to check you are able access SQL server from this machine