Newbie question: Does Power BI Report Server running in an AWS EC2 instance support AWS RDS?
Sorry for the newbie question. I'm looking for an authoritative link in the documentation that describes how or if Report Server, running in an AWS EC2 instance (aka, a VM) can connect to an AWS RDS SQL Server database. I'm trying to get a client who today runs Report Server in an EC2 instance and connects to an AWS EC2 instance running SQL Server to consider migrating the database to RDS. The client insists that things "do not work" in this configuration, including the ability to refresh reports in the web UI (or at least I think that's what he's describing as the limitation). Thanks in advance for any pointers and, especially, links to the doc that may directly address this question.
AutoUpdate PostgreSQL dataset Not Working
Hello everyone, I have a question abount the dataset autoupdate. We have some datasets connected directly to a postgresql database locatted in a rds of Amazon. If I try to update those dataset manually I have not got any inconvenients but the autoupdate is not working. This is the error that shows me, Error del origen de datos An error happened while reading data from the provider: 'Npgsql.Tls.ClientAlertException: CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider. . at Npgsql.Tls.TlsClientStream.SendAlertFatal(AlertDescription description, String message) at Npgsql.Tls.TlsClientStream.ParseCertificateMessage(Byte[] buf, Int32& pos) at Npgsql.Tls.TlsClientStream.TraverseHandshakeMessages() at Npgsql.Tls.TlsClientStream.<GetInitialHandshakeMessages>d__43.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Npgsql.Tls.TlsClientStream.<PerformInitialHandshake>d__72.MoveNext()'. The exception was raised by the IDbCommand interface. Table: calendar. Does anyone knows how to resolve this? Thanks in advanced
Issue with Gateway with only one report
Hello everyone, Has anyone ever run into an issue where a specific Power BI pbix file seemed to have adverse affects on your on prem gateway? I had a specific report that was connecting to an AWS Redshift data source and every time I would refresh the report in app.powerbi, I would get an error message saying that the gateway ran into an issue and the gateway may have been restarting (common error it seems like). But it would only happen with that report. It also appeared, although I can't confirm, that the gateway was crashing when I would try to refresh this report and then would restore itself some time later. I ended up rebuilding it completely from scratch with a new pbix file. Additional details, all of our reports use AWS Redshift as a data source. They all connect to the same cluster.
Report Sever hosted on AWS
Hi team, My customer is asking to host PBI Report Server on AWS (VMs) instead of an On-Premises Server. Reviewing PBI Server Report install requirements, I can see that is necessary to have a Windows Server for PBI Report Server and a Windows Server for SQL. Having this in mind, I think that is perfectly possible to install it on an AWS VMs...so, my questions are..... 1. Is this possible? 2. Any success case with this subject? 3. Additional considerations? Thank you.power BI reporting services Licensing
Hi All, My enterprise use SSRS and has a license for SQL Server Enterprise Edition . According link we can use power bi report server as well without pay extra. I've few questions: 1. Are the clients should pay for the service - watch and interact those reports ? 2. Is there possibility to build those reports with direct query to AWS Redshift ? 3. Is there possibility to design reports with enterprise logo same as SSRS ? Tks, DanPower BI Report Server activation and product key for cloud virtual machine EC2 in AWS
Good morning, We're managing our cloud infrastructure for some clients. We're using AWS EC2 instances. In particular, we've launched an instance (new virtual machine) with Microsoft Windows Server 2016 Full Locale English with SQL Enterprise 2016 SP1 AMI provided by Amazon. The instance runs SQL Server 2016 Enterprise Edition and all licensing is included in the AWS subscription and managed by Amazon. This means that the virtual machine is activated using digital licensing. Using a powershell script, I could obtain a product key but doesn't work when activating Power BI Report Server. For obvious reasons, I don't have access to the MS licensing portal, as it is managed by Amazon. Bottomline is: we're paying for SQL Server 2016 Enterprise licensing and all related costs, included within the virtual machine subscription. Anyone could please share experiences activating this product on cloud infrastructure? I've already opened a support ticket with AWS, but they're still scratching their heads ;-) Thanks, Pablo.