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
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.
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.