I have a paginated report that uses a "Power BI Dataset connection". I can run it fine on the desktop and on the service. But when I share the report with some of my users (who also have access to the underlying dataset) they get this error:
Could not connect to the data source.
There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. The connection either timed out or was lost.
Here's the thing.. I know the error isn't related to Analysis Server connection, because I don't have one. What I discoverd was if I made the user a Member of the workspace (ie owner of the report) then the error was resolved. If tried lowering the access to viewer, but it didn't work.
I other paginated reports deployed and all I had to do was share them, worked fine. Those reports don't use a Power BI Dataset connection so I assume that's the issue ?
Please fix this defect or at least advise of a workaround. I don't want to grant my users elevated access just to run this report.