help DAX dataset on ssas tabular for reporting services
I need to write a DAX query for a reporting services report the data source is a ssas tabular cube the datamodel is kimball dim model requirements The dataset needs to include columns from one fact table and two related dimension tables only a few columns from each table shall be included the dataset shall be filtered from SSRS parameters (both fact and dimension table) baically what I need is help writing a query that joins the three tables (inner join) as efficient as possible I am elaborating with selectedcolumns, different types of joins (related, naturalimnerjoins, lookup) and filter function I would approciate some input here
Report .rdl with special characters & upload with power Shell
I have a report with some special characters, the special characters specifically are "à, è ". When I run it or manually upload the report to the server I have no problem. But when I load the report with power shell with "Write-RsFolderContent" function I get an error. In power shell console the error is "Failed to create catalog item from 'C:\Users\rtn\Desktop\New folder\hprs\Shared Reports\Daily\Agent Activity.rdl' in '/Hash Phones Reporting Services DLL/Shared Reports/Daily': System.Exception: Failed to create catalog item C:\Users\rtn\Desktop\New folder\hprs\Shared Reports\Daily\Agent Activity.rdl : Eccezione durante la chiamata di "CreateCatalogItem" con "7" argomento/i: "System.Web.Services.Protocols.SoapException: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: Invalid character in the given encoding. Line 2399, position 44." The enconding of report is UTF-8
Date/Time Parameters in SSRS Linked Reports (PBIRS September 2021)
Hello, My organization is using PowerBI via an application that also hosts SSRS reports; currently Power BI September 2021 update is in place. There is a problem that is occurring with SSRS linked reports. When attempting to set default parameters for a linked report, PBIRS will not allow you to "Apply" the changes if there are any date/time parameters on the report UNLESS you set values for those date/time parameters. The message "A valid datetime value is required" appears, even if the RDL in question does not mark these parameters as required in its design. In previous versions of SSRS, this was not necessary. Is this fixed in a later version? Or is this a bug.Remove whitepace in table row of SSRS report
I'm unsure if this is the correct forum to ask my question. However, I've created an SSRS report in Visual Studio to publish to the Report Server. In my report, I'm experiencing spacing issue within the table cells. Image is below. This table displays counts on a column per date. For 01/04/2021, there's whitespace in which I need to remove. In the design, I've tried modifying the height and padding of the Textbox in the Table. Also, I've tried setting the CanGrow and CanShrink property to False of the Textbox in the Table. Is there anyway I can remove the whitepace?
Generate two outputs on a single Subscription
Hi everyone, I have a scenario where I am dealing with too many data-driven subscriptions being required in order to generate EXCEL and PDF files on a repository. According to the current configuration the report needs to execute twice for the same parameters in order to generate one EXCEL and one PDF. My question is if there is a way to reduce the number of report executions per subscription taking advantage of the data being already in cache and just generate the two outputs EXCEL e PDF in one go. Thank you Regards, LSuser centric reporting and report centric reporting - to capture user and report usage details.
Hi Team, I am trying to create 2 separate reports for the following, Who is using the reports? What reports are being used (and how frequently/by whom)? Basically i am looking to create 2 views of the usage data user centric reporting and report centric reporting. The User Centric Reporting is focused on PowerBI licence holders while the Report centric reporting for PowerBI is to show details regarding what reports are being used and how frequently and by whom? It would be really helpful if anyone can assist me on where to get the data for these from. Thanks in advance. Kind regards, Arjun RathinamReportServer: error execution reports
Hi, We have got the error on ReportServer when I Execute ssrs report: ReportServer_0-1!1234!12/04/2019-12:37:46:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Impossible de lire la ligne de données suivante du jeu de données « Sales ». ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Impossible de lire les données de la connexion de transport : Une connexion existante a dû être fermée par l’hôte distant. ---> System.Net.Sockets.SocketException: Une connexion existante a dû être fermée par l’hôte distant à System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- Fin de la trace de la pile d'exception interne --- à System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) à System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) à Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadBody(Byte[] buffer, Int32 offset, Int32 count) à Microsoft.AnalysisServices.AdomdClient.TcpStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- Fin de la trace de la pile d'exception interne --- à Microsoft.AnalysisServices.AdomdClient.XmlaReader.ReadEndElement() à Microsoft.AnalysisServices.AdomdClient.FormattersHelpers.ReadRowsetProperty(XmlReader reader, String elementName, String elementNamespace, Type type, Boolean throwOnInlineError, Boolean isArray, Boolean convertToLocalTime) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.ReadColumnValue(Int32 ordinal) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.SequentialReadXmlValue(Int32 ordinal) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.GetRowXmlValues(Object[] xmlValues) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.InternalRead() à Microsoft.ReportingServices.DataExtensions.AdoMdDataReaderBase.Read() à Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow() We have 2 servers: On the one part, there is SQL server and ReportingService (4CPU, 64 Go RAM) and the other part SSAS (4 CPU 32 Go RAM). When I restart the reporting service, the reports work fine : Reporting service uses 20 Go RAM! But after report reexecutions, we have the above error and i can see that reporting service uses 1Go RAM. I need restart reporting service. I don't understand the trouble. Can you help me please?PowerBI report server scale-out with NLB - bad request when open or upload PowerBI Report
I have setup 2 PowerBI Report Servers in an scale-out deployment with an NLB (https://docs.microsoft.com/en-us/sql/reporting-services/report-server/configure-a-report-server-on-a-network-load-balancing-cluster?view=sql-server-2017) When opening the load balancer URL i can login, create folders, assign permissions. But when i try to open a powerbi report or try to upload a report an error occured. In the RSPortal.log i find the following error: 2019-09-25 17:52:47.1644|ERROR|41|The remote server returned an error: (400) Bad Request.| RequestID = s_c1a68a9f-38c0-4e89-ab27-045f4ca39fbe I'm using Microsoft Power BI Report Server - May 2019. When creating a report with PowerBI Desktop for Reporting Services (also May 2019 version) and try to save that report on the report server the following error message appears: Would be glad if anyone can help. Thanks, JE
