Forum Discussion
Connection open intermittent error while reading in Analysis Services, needs retry.
Apologies for the delay in checking the post. I have resolved the issue by deleting the report's data source and creating a new one. You can achieve this by duplicating the report and then publishing it again. I hope this information is helpful to you.
I know I am late to the party, but I just ran into this error and found another reason. Maybe ti could be useful for someone in the future.
I was connecting via paginated report to a dataset developed by someone else, and when the report was accessed by some plain user, they got this very same error, whereas workspace administrators - or better yet, anyone with workspace access - ran the report successfully.
It turned out that who developed the dataset recycled an existing one, but forgot to remove RLS-related rules (RLS is not required in this particular dataset) . Removed the RLS leftovers, everything started working like a charm