topic Re: Can't Display the Visual in Report Server

Can't Display the Visual

Anonymous — Tue, 08 Jan 2019 12:35:09 GMT

Thanx in advance for any assistance or suggestions.

A report that has been runnig fine suddenly wont display, See pic below

Servers have been rebooted.

Latest versions of powerbi installed

Error: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item '/ReportFolder/ReportName' is not allowed for this item type

Re: Can't Display the Visual

Anonymous — Wed, 09 Jan 2019 18:40:35 GMT

Have you checked your datasource credentials? If your data source is a SQL server follow the below steps.

Go to the folder where your PowerBI report/dash is located in Report Server. Click the 3 dots to the right of the report's name. On the pop out window, click 'Manage'. Now on left panel click Datasource.

Under the Credentials section:

If you are using a SQL account make sure it is set to Basic Authentication, the credentials are correct, and test the connection.

If you are using AD, choose Windows Authentication, verify the credentials are correct, and test the connection.

Regardless if you are using a SQL account or AD account, make sure the account has READ access to the tables/views in SQL Server.

Re: Can't Display the Visual

Anonymous — Thu, 10 Jan 2019 11:13:57 GMT

Thanx for response

The user accounts have full access.

Tested the connecetions successfully.

Still the same issues

Re: Can't Display the Visual

Anonymous — Mon, 14 Jan 2019 08:33:11 GMT

This issue is affecting all our dashboards.

There are were no code changes or deployments.

It might be related to CU13 for SQL Server 2017 as that is the only change to the box.

Where we have measures without filters the dashboards work but as soon as filters are applied they fail.

Re: Can't Display the Visual

Anonymous — Tue, 15 Jan 2019 07:43:21 GMT

Problem solved:

Uninstalled CU13 for SQL Server 2017.

All working fine now.