rdl

12 Topics

PowerBI Expression Evaluation Thread Delegation
I am working on locale-aware formatting using a custom C# helper, whose DLL is referenced in the report server. I am updating the Thread Culture to the specific culture so that the ToString() can format the datetime and amount correctly. I didn't want to use ToString(format, CultureProvider) as this is slower than ToString() and can take more time to load the data if the report contains 100k or more rows. I set the ThreadCulture in the constructor of my helper class and create an instance of it in the report. I am using this approach to have a centralised formatting helper and have control over it. Is it possible that the report may delegate the expression evaluation to a different Thread?
Solved
Anonymous
6 months ago Place Report Server
919Views
0likes
6Comments
Passing parameter in Paginated Report
Hello, I have created 5 paginated reports in Report Builder. All of them contain tables only and few multiselect parameters. In the first report you can select particular row and click it, report will pass all values from all parameters to the 2nd report. On the second report you can click and 3rd report opens and so on. I'm passing parameters values in URL however the limitation of that solution is that URL cannot be longer than 2000 characters and this is my issue. I would like to set it up like this: user can select all values in all parameters but when user clisks on particular row, report will grab only related to that row values and pass only those singe values into parameters to the next report instead of passing all parameters values. Is it possible? 🙂 Thanks
mora11
3 years ago Place Report Server
447Views
0likes
0Comments
count greater than 1000 (report builder)
I need an expression to count (identify) those amounts greater than 1000 from an existing column in powerbi paginated reports. column (payments) $54 $23 $40 $14 $28 table sum of the payment = 239 count payments under $25 = 2 (this is the expression that I need) Please your help is greatly appreciated. no experience in rdl. PaginatedReport PaginatedDino
Solved
BeginnerBI
3 years ago Place Report Server
1.1KViews
0likes
1Comment
RDL migration: SSRS to Power I Report Server (PBRS), issue with File Share Subscription
Hi Team, I'm migrating all the Paginated Reports from SSRS to PBRS. I was following the approach layed out in below links. https://github.com/microsoft/sql-server-samples/blob/master/samples/features/reporting-services/ssrs-migration-rss/ssrs_migration.rss https://businesswintelligence.com/content/80/ssrs-simple-migration-script All the reports/rdl are being migrated, but isssue i'm encountering is any reports that have atleast 1 File Share subcriptions those report subscriptions are not being migrated and it throws below error. --- End of inner exception stack trace ---; processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: e ERROR: Data source 'DataSource1': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: e ERROR: An exception has occurred in data source 'DataSource1'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ... processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: [AbnormalTermination:ReportProcessing], Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper.Open() at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass5_0.<OpenDataSourceExtensionConnection>b__0() at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.HandleImpersonation(IProcessingDataSource dataSource, DataSourceInfo dataSourceInfo, String datasetName, IDbConnection connection, Action afterImpersonationAction) at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName) --- End of inner exception stack trace --- I see no issues in migrating Email Subscriptions or Reports... only File Share Subscriptions are failing. These reports have no issue and are executing perfecting in SSRS. Any clue's?
Gainer
3 years ago Place Report Server
675Views
0likes
1Comment
January 2022 PBI RS: Parameter values from query string are not properly decoded in RDL report
We found this issue when we upgraded from May 2021 to Jan 2022. We are loading RDL report in our application using iframe. We are using report URL and pass parameters in query string. Since URL have parameter and its value, we are doing URL encode before setting iframe source. Example: https://reportserver/reports/report/Customerfolder/TestReport?ConnectionString=server%3dSQLServerName%3b+initial+catalog%3dTESTDB&rc:Parameters=Collapsed&rs:Embed=true&rc:Zoom=100 Here parameter ConnectionString value is server%3dSQLServerName%3b+initial+catalog%3dTESTDB Parameter value used to get properly decoded in all previous versions: In Jan 2022 this seems to be broken. It decodes everything except + Anyone seeing this issue with January 2022 PBI report server?
Solved
SagarSalvi
3 years ago Place Report Server
5.2KViews
0likes
11Comments
How to extract SSRS Reports RDL using Web Service from PowerBI.com
Hi there, Currently, we have a on-premises SSRS 2016 (SQL Server Reporting Service in standalone mode) server and it has many paginated reports (RDL files) with pre-formatted business requirement. One of our company's application uses the Report Server Web Service Endpoints functionality (i.e. http://mySSRSsrv/ReportServer/ReportService2010.asmx ) to extract many reports automatically into various format such as Excel, CSV and PDF per needs. See this for more: Report Server Web Service Endpoints - SQL Server Reporting Services (SSRS) | Microsoft Docs We intend to migrate all of the RDL’s SSRS files with 2 x design alternatives- (Prefer Option 1) Deploy all paginated reports RDL's into the Power BI Service workspace in the cloud (knows as www.powerbi.com) . However, how can above application extract the RDL’s report output into Excel, CSV and PDF as to our knowledge PowrBI.com service does not provide or expose any web-service or alternative to achieve that? Any help please. Note we have PBI Premium capacity. (Option 2) Deploy all paginated reports RDL's into an On-premises Power BI Report Server. But once again, how can above application extract the RDL's report output into Excel, CSV and PDF as to our knowledge PowerBI Report Server does not offer or expose any web-service to acheive that? Any help please
Solved
kaushikmakadia
3 years ago Place Report Server
3.5KViews
0likes
2Comments
Embedding multiple RDL Configurations in One
Hi Everyone, I Have configured multiple company forms using the Report Builder and different dataset. However, I wanted to embed all those report builder configurations in one ( each configuration is structurally different) . lets say I have 4 different kinds of Documents ( A,B,C,D) , I want to find a way that when a user chooses parameter A , Report A would show up and so on. Is there any existing ways to do this. I have checked this thread and it doesn't serve my purpose: https://community.powerbi.com/t5/Report-Server/Multiple-reports-in-a-single-RDL-file-Power-BI-Report-Builder/td-p/1447395
Solved
Anonymous
3 years ago Place Report Server
1.1KViews
0likes
1Comment
paginated reports interactive parameter dropdown lists not displaying data
From 2022-03-31have interactive paginated reports stoped display data. The reports has worked before. After I choose parameter values from dropdown lists (From, To and Organisation) and push <View Reports> nothing happends . It seems like report is not running the query. The problem seems to be, that the choosen parameter values in the dropdown list is not used in the query. If I manually enter the the values in parameter boxes, if works, sometimes. I have tried to use different web browsers (Edge, Chrome, Fire Fox and Opera) and have the same issue. The "Power BI Embedded" service is Gen.1 in Prod environment and Gen.2 in Dev environment. When I use the local .rdl file, everything works.
Solved
Anonymous
4 years ago Place Report Server
3.3KViews
1like
4Comments
Passing slicer selected values to PowerBI report .rdl not being retained
I have a powerbi report that has a matrix, so I've added in a button that takes the end user to an identical .rdl that will export in a more "friendly" format. I've had to use the Azure link that generates when the report is shared to get this link to work since the end users are outside of my organization, however in doing this, it appears the URL gets reformatted somewhere in between the click and report generation and the values selected within the slicers of the powerbi are not retained the URL passed to the .rdl. Any ideas on how to get this to stay so that the report will auto generate based on the slicers chosen? powerbi URL: var __baseURL1 = "https://azure.microsoft.com/email/?destination=https%3A%2F%2Fapp.powerbi.com%2FMobileRedirect.html%3Faction%3DOpenRdlReport%26reportObjectId%3Dreportidisretainedinurlbelow%26ctid%3Dthisissomethingthatdoesnotshowupbelow%26groupObjectId%3Dthisissomethingthatdoesnotshowupbelow%26OpenAppFromWindowsPCAndTablet%3Dfalse%26emailSource%3DReportInvitation&p=differentreportinvitationthanbelow" var __baseURL2 = __baseURL1 & "?rs:Embed=true&rp:YrQtr=" & SelectedTimePeriod & "&rp:O=" & SelectedO & "&rp:C=" & SelectedC & "&rp:P=" & SelectedP & "&rp:D=" & SelectedD & "&rp:T=" & SelectedT & "&rp:AnStart=" & SelectedAnStart & "&rp:AnEnd=" & SelectedAnEnd & "&rp:DStart=" & SelectedDStart & "&rp:DEnd=" & SelectedDEnd & "&rdl:format=EXCELOPENXML" RETURN __baseURL2 this is the URL it changes to: https://app.powerbi.com/groups/cc05b225-b719-4c9d-a42a-baa017b11c1c/rdlreports/sameasabove?openReportSource=ReportInvitation&ctid=differentthanabove
ashleytanoe
6 years ago Place Report Server
700Views
0likes
1Comment
problem with paginated reports, pbi-reportserver on non-standard ssl-port
hi all, i hope that somebody can help or at least point me to a possible solution as this issue is driving me crazy. we are serving 3 websites (intranet on port 443, power bi rs on port 4000 and old ssrs on port 5000) on this server, the intranet via iis (own development) and the 2 report-server-portals. all important features are working so far, my old reports can be viewed on the new power bi rs server (on prem, licensed via SQL EE with SA), pbix are working and nearly everything is fine. for a long time i developed all rdl reports in visual studio and uploaded them to the portal so the following issue wasn't encountered before. after setting up the new power-bi server and planning on rolling out the features to the endusers, i tested to build - or open existing - reports with the small report builder that is downloadable when using the link "+ -> paginated report". when i try to open an existing report, i get the error message "path is too long or doesn't start with a '/'". this message is shown in the report builder and you can find it in the server log. when the report builder opens, i can successfully connect to "https://server.domain.tld:4000/reportserver" and i can see all reports. it's also possible to open a report. previewing the report in the report builder results in an "404 - not found" error. the server in the status bar at the bottom shows adress above without port 4000 but it says "connected" and i have a "disconnect" link. my guess is, that only the reportbuilder has a problem with the non-standard-ssl-port. when i changed the port for this pbirs instance to 443 (temporarily shutting down the intranet before) everything was working like a charm. power bi desktop on the other hand doesn't seem to have a problem with this configuration. it's possible to open the pbix with the edit link in the portal and the report can be modified and saved flawlessly. it's also possible to open power-bi-desktop, create a new report and save it to the pbirs. any ideas, hints? do you need more config informations? i didn't wanted to include to much config-details to keep this post as short as possible. thx so far for reading this post :).
Solved
Anonymous
6 years ago Place Report Server
2.3KViews
0likes
1Comment