Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

dotcs_farrellv

Paginated report using Power BI Dataset reports Analysis Server error (even tho I don't have one)

Submitted by on ‎10-27-2019 10:26 PM

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. 
Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎10-29-2019 02:01 AM

@dotcs_farrellv 

 

You may check if it is a classic workspace.

dotcs_farrellv
Frequent Visitor
‎10-29-2019 03:04 PM

Thanks for the idea, but you can't promote the paginated reports to classic workspaces. It's a premium workspace. 

dotcs_farrellv
Frequent Visitor
‎10-29-2019 03:48 PM

I found a workaround. As well as Read access to the Dataset I can grant them Build access. It means I have to give that user access to the entire Dataset, not just the information exposed on the report. But it's better than giving them access to all the reports in the workspace (which is what happened when I made them a member of the workspace).

 

I looked up the permission

https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions

 

Is it supposed to be the case that this permission needs to be granted ? Or is that part of CRI 149496582 or a similar defect ? If it is supposed to be granted, can I suggest that you make that limitation of using reports more wildly known as it was very difficult to find. I'm not sure I want my users to have that permission, it lets them do far more than just run my report.

Idea Statuses