topic Re: Automatic data actualization in Report Server form SQL Server Analysis Services in Report Server

Automatic data actualization in Report Server form SQL Server Analysis Services

Dreamer_Argento — Tue, 03 May 2022 14:38:14 GMT

Hi,

I have a report that uses several datasources. One of them is SQL Server Analysis Services.

When data is automatically updated in report located in report server, all tables are update but not tables which their source is SQL Server Analysis Services. Does anybody knows the solution of this issue?

Thanks in advance.

Re: Automatic data actualization in Report Server form SQL Server Analysis Services

TOK — Thu, 05 May 2022 09:13:22 GMT

Hi,
please check if you did enable load for your SSAS dataset.

It is also conceivable that your SSAS dataset did update, but the data in your multidimensional modell was not up-to-date.

Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ

Re: Automatic data actualization in Report Server form SQL Server Analysis Services

v-henryk-mstf — Fri, 06 May 2022 08:42:29 GMT

Hi @Dreamer_Argento ,

Agree with @TOK view.

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

Re: Automatic data actualization in Report Server form SQL Server Analysis Services

Dreamer_Argento — Fri, 06 May 2022 11:47:49 GMT

The issue was solved. I had an error in user permissions. Thanks !