Migration of user accounts from Previous Organization to New one
Team, Need an urgent step by step assistance to migrate all the user accounts (after a domain change post merger i.e. post merger user was changed from [email protected] to [email protected]) from previous organization to the new Organization without impacting the current Power BI setup post merger. Best Regards Power BI Enthusiast
Migrating from Reports Server to Pro/ Premium
The current senario: Have Power BI Reports on the Report Server that are configured to be accessible/ viewable via three different Dashboards using Share Point as the interface. Each Dashboard and reports residing are controlled by permissions set at the AD level and in Share Point. Looking for ideas on how to transition the reports to Power BI Premium (via Service). Is it possible to create sub workspaces with different permissions? Design ideas of the Interface would be welcome. Thank you.New User Group & Announcement of the SSRS/PBIRS Migration Tool to Power BI
Hello All, Please check out our new user group. And while you are there, register for our March event Paginated Reports with and without Power BI Datasets: When, Why and How? We just recently announced the expansion of our migration tool here. Watch Patrick's demo video from Guy in a Cube. Have any questions, concerns or feedback, drop them in the discussion section of the user group We look forwad to hearing from you soon!
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?
How to migrate SSRS reports to Power BI Report Server?
I found this Microsoft documentation but I couldn't anywhere on the page what "-e" means. I looked at the ssrs_migration.rss file and there is no mention of what -e Mgtm2010 even means. Do I need to use -e in my environment? If so, instead of Mgmt2010, what should it be? Thanks!
Issue with Encryption Keys
Hi! I am in the middle of separating Power BI Report Server portal to another machine (lets call id Machine2) from current server where it is running now (lets call it Machine1). I want to use the same SQL database from Machine1 because of not compete'ing for resources (mainly CPU) in this scenario. I have an issue with decrypting restored encryption keys and I can't overcome it. I've connected to my database, restore the encryption key (backed up previously on Machine1) and the portal is working fine. I can see all my folders/reports. The problem starts when I try to open Manage->Data Sources because it looks that sensitive information can't be encrypted. I get an error: and when clicking OK - the portal tries to redirect me to the wrong report link with "/browse/" instead of "/powerbi/" inside. In the RS Portal log file I get like below. Can someone help me with this? What could be the reason? My new portal is upgraded to Sep21 version. 2021-10-06 11:07:51.1782|ERROR|7|Decryption failed, Current user: (edited -my service account user)| RequestID = s_abf2472f-056a-4375-811e-41a787c25913 System.Security.Cryptography.CryptographicException: Bad Data. at System.Security.Cryptography.CryptographicException.ThrowCryptographicException(Int32 hr) at System.Security.Cryptography.Utils._DecryptData(SafeKeyHandle hKey, Byte[] data, Int32 ib, Int32 cb, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode PaddingMode, Boolean fDone) at System.Security.Cryptography.CryptoAPITransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount) at System.Security.Cryptography.CryptoStream.FlushFinalBlock() at System.Security.Cryptography.CryptoStream.Dispose(Boolean disposing) at System.IO.Stream.Close() at Microsoft.BIServer.HostingEnvironment.Cryptography.SymmetricKeyCrypto.DecryptInternal(Byte[] data) 2021-10-06 11:07:51.2022|ERROR|7|OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.BIServer.HostingEnvironment.Cryptography.Exceptions.CryptoException: Decryption Failure ---> System.Security.Cryptography.CryptographicException: Bad Data. at System.Security.Cryptography.CryptographicException.ThrowCryptographicException(Int32 hr) at System.Security.Cryptography.Utils._DecryptData(SafeKeyHandle hKey, Byte[] data, Int32 ib, Int32 cb, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode PaddingMode, Boolean fDone) at System.Security.Cryptography.CryptoAPITransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount) at System.Security.Cryptography.CryptoStream.FlushFinalBlock() at System.Security.Cryptography.CryptoStream.Dispose(Boolean disposing) at System.IO.Stream.Close() at Microsoft.BIServer.HostingEnvironment.Cryptography.SymmetricKeyCrypto.DecryptInternal(Byte[] data) --- End of inner exception stack trace --- at Microsoft.BIServer.HostingEnvironment.Cryptography.SymmetricKeyCrypto.DecryptInternal(Byte[] data) at Microsoft.BIServer.HostingEnvironment.Cryptography.Crypto.Decrypt(Byte[] protectedData, String tag) at Microsoft.BIServer.HostingEnvironment.Cryptography.Crypto.DecryptToString(Byte[] protectedData) at Microsoft.ReportingServices.Portal.Services.ODataExtensions.DataModelDataSourceExtensions.ToDataSourceWithoutSecret(DataModelDataSourceEntity dataSourceEntity) at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Model.PowerBIReportRepository.LoadDataSources() at Model.PowerBIReport.get_DataSources() at lambda_method(Closure , PowerBIReportRepository ) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at Microsoft.AspNet.OData.Query.Expressions.SelectExpandBinder.Bind(Object entity, SelectExpandQueryOption selectExpandQuery) at Microsoft.AspNet.OData.Query.ODataQueryOptions.ApplySelectExpand[T](T entity, ODataQuerySettings querySettings) at Microsoft.AspNet.OData.Query.ODataQueryOptions.ApplyTo(Object entity, ODataQuerySettings querySettings) at Microsoft.AspNet.OData.EnableQueryAttribute.ExecuteQuery(Object responseValue, IQueryable singleResultCollection, IWebApiActionDescriptor actionDescriptor, Func`2 modelFunction, IWebApiRequestMessage request, Func`2 createQueryOptionFunction) at Microsoft.AspNet.OData.EnableQueryAttribute.OnActionExecuted(Object responseValue, IQueryable singleResultCollection, IWebApiActionDescriptor actionDescriptor, IWebApiRequestMessage request, Func`2 modelFunction, Func`2 createQueryOptionFunction, Action`1 createResponseAction, Action`3 createErrorAction) at Microsoft.AspNet.OData.EnableQueryAttribute.OnActionExecuted(HttpActionExecutedContext actionExecutedContext) at System.Web.Http.Filters.ActionFilterAttribute.OnActionExecutedAsync(HttpActionExecutedContext actionExecutedContext, CancellationToken cancellationToken) --- 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 System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.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 System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.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 System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.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 System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext().| RequestID = s_abf2472f-056a-4375-811e-41a787c25913 Regards, MarcinMigration from Power BI service (March 2021 version) to on-premise report server (Jan 2021 version)
Hi All, We had created a report on Power BI service on March 2021 version. We want to migrate the report to an on-premise report server(private server) which is based on January 2021 version. Would it be possible to migrate? If yes, please suggest the process and stesp to achieve it? Thanks in Advance
