Report server On Premise refresh failed
Dear all i have a strange problem with our PBI On-Prem 2024.sept version server. A lot of reports are not refreshing sheduled, nor manual. It says "Completed Data Refresh", last run: a date from yesterday. If i add a new schedule, it keeps saying "Refreshing". in PBI server Logs i cannot see any serious or refresh related error. On MSSQL server Agent, all scheduled jobs did run with OK result. I installed the PBI server on another machine, copied the ReportServerDB and TempDB and the problem is still the same on the new server. What sould i check? Thank you for your help!
MySQL: Retrieval of the RSA public key is not enabled for insecure connections.
I am unable to refresh a MySQL 8 datasource in a on prem version of Power BI reporting server. When I go in the datasouce and enter credentials under with Basic Authentication type and test I get the error: MySQL: Retrieval of the RSA public key is not enabled for insecure connections. My versions are as follows: PBRIS on premisis version 15.0.1112.48 Mysql .NET 8.0.28 I am able to refresh the datasource in PowerBI Desktop RS version Version: 2.117.984.0 64-bit (May 2023) This is apprently a common issue with MySQL and the common fix quoted is add allowPublicKeyRetrieval=true to the connection string except I cant see how the edit the connection string.
Use the webpage backend and the IIS as a proxy to the ReportServer
Hi, My company currently uses SyncFusion as graphical library and wish to change to the Power BI totally on-prem through the Report Server. We have hundreds of customers over the internet that will see the reports embedded in a web page hosted in an IIS. The problem is that the iframe goes direct to the Report Server, and my company doesn't want this. My company wishes that the iframe( or another thing that allow embedding reports in web pages ) goes to the backend, and the IIS machines do the requests to the Report Server and return the results to the external customer, to protect the Report Server and avoid other people to see the report or even external customers accessing data from other external customers. Our intention: -Upload our reports to the ReportServer -Create hidden filters in the reports to avoid an external customer see data from another external customer -Embed these reports through an iframe( or another thing ) in a page hosted in an IIS -Use the backend as a proxy to avoid customers change the filter that goes through the URL, avoid direct access to the URL through the web browser, and avoid random people over the internet to access the ReportServer. Using the IIS and the network security as a protection to the ReportServer Is it possible? Ps: We will not use the CustomSecuritySample of the Report Server. We tried, but we don't like it. Best Regards, Luis
