Steps to use Cyber Ark to manage Data Source Credentials with on Prem Power BI report server
Hello, I am getting mixed results when trying to determine if Power BI report Server can use Cyber ARK PVWA for managing Data Source account passwords. Using PVWA enables Web application to connect to a credential managed Vault to retrieve service…
![](https://techprofile.blob.core.windows.net/images/EeFogQFAAwAAAAAAAAAAAA.png?8D8E8B)
how to schedule power bi reports for email delivery?
how to schedule power bi reports for email delivery?
![](https://techprofile.blob.core.windows.net/images/EeFogQFAAwAAAAAAAAAAAA.png?8D8E8B)
Cannot connect to SQL Database. Please contact SQL server team for further support
Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…
Place Rounded Border in Reporting Services
I am currently using Report Builder, and I would like to know the way to place a rounded border in the corner of a table or text box Currently it can only be squared and I would like a border like this: is it possible to do this? if possible how would…
Matrix's backgroud color
HI, I NEED A HELP I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K. I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX... HOW CAN I DO THIS…
Error on report after upgrading to build 16.0.1115.92
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). In early May…
Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)
After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0,…
How to upgrade an eval installation of SSRS to full
I have an installation of SQL 2019 and SSRS 2019. The SSRS is an eval installation and has expired. I have the ssrs key from the installation of SQL. I have tried the modify option in Apps And Features but it is greyed out. I used the sql installation…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Setting up SQL Auth for Azure SQL DB via SSRS
Hello, I am referring the below MSFT doc : https://learn.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-ver16 wherein confused with the below statement: SQL Database supports only SQL Server…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Highlight cell or row in SSRS Tablix
Hello, I have a Tablix with multiple temperatures values for a patient taken in a day. Was wondering if I can highlight the row/cell with the highest temperature, in this case 101.5 Let me know if this can achieve via expression. Thanks, Ali.
![](https://techprofile.blob.core.windows.net/images/mJ14u-Q6KUq_a1oQj1j8iw.png?8D940C)
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Upgrading SQL Server having multiple instances
Our SQL is of 2014 RTM. Planned to upgrade it to 2014 SP3 in the first place later to 2022. And our SQL Server do have extra 2 instances as being used for replication DBs. I saw rolling upgrade as solution to HA environment. But nowhere could I see…
Need to filter data in Tablix
I have created a tablix where I need to filter the data, I have used the following expression in the Tablix properties and I am not getting the expected results IIf(IsNothing(field1.Value) OR IsNothing(field2.Value), 1, 0) The above formula is…
Finding SQL Server 2022 Web Edition License Key for SSRS
I am presently licensing SQL Server 2022 Web Edition on an SPLA license on a hosted cloud server. The hosting partner does not presently offer a cloud server image for SQL Server 2022 which includes Reporting Services. I understand that a SSRS license…
Hey team, I am using uaa login url for custom authentication while accessing web reports.
The problem is that when I am using windows authentication, I am able to see the cookie for the ServiceState API, but if I configure it to use the custom authentication which is by using uaa as mode of authentication mechanism I am not able to see the…
SRSS REST API get the content of the Report
Hello, I am new to SRSS and we were introduced REST API being available. I am confused about the swagger/OpenAPI document with regards to this endpoint /Reports({{Id}})/Content/$value Here are my questions: What does this return? Is this the content…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Issue installing MSSql server on Ubuntu 22.04
While trying to install mssql server on my Ubuntu VPS following Microsoft documentation, i'm encountering error 504 running the command below. root@eloquent-engelbart:~# curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
SSRS: Subscription
I'm working on configuring the the Microsoft Subscription. I cannot seem to find the error. I found errors 37 and 42. 2024-06-06 10:04:26.3373|ERROR|54|OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown…
No Rows Message in Report Builder is not turning Red color in exported .pdf file
Hi All, I have developed on main report which contains many subreports in Report Builder. I have set the No Rows Message in Main report as well as Sub Report. No Rows message color made to Red Color. But problem is that, While run the main report and…
Creating Dataset in VS2020 using SQL query rather than visual designer
I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?
Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536
Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)