What permissions are needed to load data in a shared dataset on SSRS 2016 Preview?
I've created a shared dataset in both BIDS and Report Builder. The data source is set up to use a windows service account. I've also tried it with a sql user that is verified to work.
In both BIDS and Report Builder, data is returned. When I go to the report portal and try to preview the data, or try to add it is a dataset to a mobile report, it throws an error:
I've given permissions at the root folder level to NT Authority\Authenticated Users and to my department's AD group, with all rights granted.
I'm not really sure what else to do, or where to even check to see what the error actually is. Any help is appreciated.
So I figured it out - it actually had nothing to do with permissions. A fiddler trace showed a 422 and 500 errors.
422: the Dataset could not be processed. The 500 said
500: There was a problem getting data from the Report Server Web Service: System.Web.Services.Protocols.SoapException: The JSON SharedDataSet Table renderer cannot parse the supplied report...
This lead me to check the actual query coming back, which had a Geography data type coming back for one of the fields. When I removed this from the query, everything worked fine.
- UNION ALL where value of second SELECT depends on the first
- Getting the slice index in a pie chart
- Date picker not visible on SSRS report for some users on both Chrome and IE
- Dynamic SSRS LInk
- SSRS Expression Divide by Zero Error
- Using DevExpress XtraReport Constructor with parameter
- Two Lists with separate groupings on the same page
- SSRS report expression issue
- Could not load assembly Microsoft.ReportViewer.Common, despite installing the prerequisites
- Unable to upload rdl SSRS 2016
- Fill Color based on Cell Value
- SSRS Data-Driven Subscription: Character Limit on To: Field for Emails
- =WeekdayName(weekday(Today())) gives me tomorrow
- Dynamic formatting in SSRS matrix column cells
- SSRS Report Server - Email on failure?
- Location to place favicon for report viewer / report manager
- ssrs error Maximum request length exceeded
- Tablix: Repeat header rows on each page not working
- User defined filters and sorting options for report builder
- SSRS Query execution failed for dataset
- SSRS How to repeat the table header on each page in print preview
- curl with NTLM succeeds but HttpClient with NTLM credentials fails 401
- SSRS Dynamic column names
- How to open an .rdl file in Visual Studio
- How do I add a character at the end of a field to get the total to 100 characters?
- SSRS Formatting for negative numbers
- The operation cannot be started by an account that uses SQL Server Authentication error When running ssis from stored proc in SSRS
- SSRS - When navigating to a linked website or report, then navigate back, lose scroll position and parameters
- SSRS Web Service URL Provides an Error (500)
- Horizontally and vertically Totals in RDLC Matrix