How to collect SQL Profiler Logs to resolve any database issues?
Collect SQL Profiler: Most of the time when we want to check for any dead lock of problem in the database, we ca collect SQL…
Category MS Tips
Microsoft BI technologies (MSBI), including SSRS, PBIRS, SSAS, and Azure Analysis Services. Troubleshooting and Problem-Solving articles regarding above technologies. TSG’s of other kind of troubleshooting.
Read MoreHow to collect SQL Profiler Logs to resolve any database issues?
Configuring SQL Server 2022 Reporting Services Using Automation
Configuring SQL Server 2022 Reporting Services Using Automation: Certain people have some queries and questions on how to configure the SSRS/PBIRS with PowerShell scripts. In…
The operating system returned the error ‘5(Access is denied.)
The operating system returned the error ‘5(Access is denied.): When we restore any database or report server database for SSRS/PBIRS we get this kind of…
Upgrade/Migrate a Reporting Services (SSRS)
Migrate a Reporting Services: Migrate or upgrading SSRS is both same at certain extent. Reason being is simple, if you have SSRS 2016 and below…
We couldn’t connect to the Analysis Services server
Power BI Reports Fails Using Direct Query Mode In PBIRS: If you old or new build of report server we can see this issue when…
Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version
Excel Rendering Extension: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version.…