aws rds

3 Topics

Best DataBase option for a Power BI on-premise
Hello everyone, at my work we are trying to design a cloud database solution (possibly AWS RDS) as a source data to aPower BI on-premise instance Do you know what kind of DB solution is better with an on-premise BI: SQL Server, MySQL, Postgre etc?
plane-kitchen
2 years ago Place Report Server
762Views
0likes
2Comments
Issue while migrating Power BI server database to AWS RDS
HI All, We are facing issues when trying to migrate the power bi report server database which we have on the standalone SQL server instance to a AWS RDS. We were able to restore the database to RDS using native back up file but unable to configure the power bi report server with the restored database. We get below error message when trying to configure the database. Not sure what permissions we are missing. What permissions we will need to be able to make this work. System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper) at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script) ClientConnectionId:3abb6216-bd88-451a-bb3a-8cea85ba9d11 Error Number:15247,State:1,Class:16 Thank you,
Solved
RVK
4 years ago Place Report Server
1.2KViews
0likes
2Comments
Connection to aws rds mysql
Hi all, I am new to PBI and I am facing a problem with the connection PBI report server with AWS rds DB on MySQL. I have read a lot of articles and came to the conclusion, that I need to install an "on-premise gateway" somewhere in AWS EC2... Is this right, or we have some other option? Thanks in advance!!!
Anonymous
5 years ago Place Report Server
8.2KViews
0likes
19Comments