Reply
Frequent Visitor
Posts: 5
Registered: ‎01-08-2019

Can't Display the Visual

Hi

 

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

 

 

 PowerBI_Cantdisplayvisuals.PNG

SQL New Member
New Member
Posts: 1
Registered: ‎01-09-2019

Re: Can't Display the Visual

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.

Frequent Visitor
Posts: 5
Registered: ‎01-08-2019

Re: Can't Display the Visual

Thanx for response

The user accounts have full access.

Tested the connecetions successfully.

Still the same issues

 

Frequent Visitor
Posts: 5
Registered: ‎01-08-2019

Re: Can't Display the Visual

[ Edited ]

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.

Frequent Visitor
Posts: 5
Registered: ‎01-08-2019

Re: Can't Display the Visual

Problem solved:

Uninstalled CU13 for SQL Server 2017.

All working fine now.