The Dos and Don'ts of migrating from other BI tools to Power BI!
"I have so many customers wanting to migrate from legacy BI tools to Power BI. They are concerned that their current BI tool has an uncertain future. Licence renewals are looming and in the current economic climate organisations are looking to save money. Power BI is not only a lot cheaper than other BI tools, it’s a better tool overall and since Microsoft continues to make big investments in it then migration is clearly a no-brainer." This talk is about what to watch out for when it comes to migration to Power BI from legacy BI tools.Power BI, Excel and Paginated Reports – better together!
In today's data-driven world, it's no secret that effective reporting is essential for successful decision-making. However, not all users have the same reporting preferences. Some prefer Excel, others prefer Power BI, and some require printed versions of the data. The good news is that recent updates to Excel, Power BI, and Paginated Reports allow for more integration and flexibility in meeting these reporting needs. In this session, we will explore different ways to leverage the strengths of Excel, Power BI, and Paginated Reports to create powerful and insightful reporting solutions that cater to all users' needs. Our goal is to provide attendees with the knowledge and tools they need to meet the diverse reporting needs of their organizations and stakeholders. Join us for an informative and engaging session that will help you take your reporting to the next level.Encore Power BI, Excel and Paginated Reports – better together!
In today's data-driven world, it's no secret that effective reporting is essential for successful decision-making. However, not all users have the same reporting preferences. Some prefer Excel, others prefer Power BI, and some require printed versions of the data. The good news is that recent updates to Excel, Power BI, and Paginated Reports allow for more integration and flexibility in meeting these reporting needs. In this session, we will explore different ways to leverage the strengths of Excel, Power BI, and Paginated Reports to create powerful and insightful reporting solutions that cater to all users' needs. Our goal is to provide attendees with the knowledge and tools they need to meet the diverse reporting needs of their organizations and stakeholders. Join us for an informative and engaging session that will help you take your reporting to the next level.Sean Donovan Presents: Migrating your Power BI Premium Capacity to Fabric
Featured Topic: Migrating your Power BI Premium Capacity to Fabric Teams meeting link: https://teams.microsoft.com/l/meetup-join/19%3ameeting_N2YxOTcxODQtNGNkOC00MDdjLTgyOTQtNDM0ZDVmZDE2NDEy%40thread.v2/0?context=%7b%22Tid%22%3a%2272f988bf-86f1-41af-91ab-2d7cd011db47%22%2c%22Oid%22%3a%2213eb2715-e201-406b-98b0-a37387d3b1aa%22%7dMigration 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?
