topic Migrating Data Sources in Developer

Migrating Data Sources

bbeer — Mon, 09 Aug 2021 14:59:12 GMT

Hi,

My company is working to migrate the DB we use for our PBI reports from SQL Server to Azure cloud.

The name of the server and DB will remain the same. Will I have to change data source type in all of my reports or will Power BI automatically acknowledge the change in source type?

Thanks in advance!

Re: Migrating Data Sources

Greg_Deckler — Mon, 09 Aug 2021 15:06:15 GMT

@bbeer How are you migrating to Azure, as IaaS (a VM) or to Azure SQL DB or Azure SQL Managed Instance or ?

Re: Migrating Data Sources

bbeer — Mon, 09 Aug 2021 18:25:27 GMT

@Greg_Deckler I believe it is being migrated as a VM.

Re: Migrating Data Sources

Greg_Deckler — Mon, 09 Aug 2021 18:45:32 GMT

@bbeer Well, if it is a VM then it really is just a SQL Server so you would access it using the same connector.