Automatic data actualization in Report Server form SQL Server Analysis Services

[Dreamer_Argento]

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.

[Dreamer_Argento · Accepted solution]

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

[v-henryk-mstf]

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

[TOK]

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