Migration from On-Prem File Share to Azure Blob Issues

---

Anonymous wrote:

Scenario:

Customer's Power BI data model is built using text files and excel spreadsheets that are stored on an on-premise file share using a combination of 'Text/CSV' and 'Folder' data sources.  They also use a 'SQL Server Database' data source that is also stored on-prem.   This model has been published to the PBI Service and both on-demand and scheduled refreshes occur as expected and complete successfully using the customers on-prem gateway server.

 

Customer now wants to migrate all of their text and excel files to Azure Blob storage while leaving the SQL database on-prem.  The expectation is that the Power BI Service will access the text and excel files via the Azure back end and still use the gateway to access the on-prem SQL database.

 

Issue:

Using Power BI Desktop, the data sources are changed as needed to point to the Azure Blob storage location.  Two different migration methods were tested:

1. Create a new data source and change existing queries to reference the new data source in the 'Advanced Editor' view of the existing queries.
2. Change existing query to point to Azure Blob Storage in Advanced Editor.

 

---

Anonymous

I don't have any problem when refreshing a dataset importing data from Azure Blob storage. It doesn't need any gateway. As to your migartion methods, I don't know much details, however I'd suggest you follow below steps.

1. "Get-data" from the connector "Azure Blob storage".
2. Delete the csv table from on-premise file and rename the table from step 1 with the deleted table's name.
3. After all "Delete and Rename" from step2, configure the credential for the Azure blob storage in the dataset refresh page.