Forum Discussion
Dataflow fails to refresh
We are able to query the data via the dataflow using SQL server & Oracle RDBMS. Refreshes fail with the same message: Error: AzureBlobs failed to get the response: 'The underlying connection was clo...
Hi, thanks for asking.
We are using SQL Server and Oracle as our sources. Both refresh without issue via the On-Premise data gateways. The issue arrises when we attempt to refresh the dataflows built upon the datasources. I am thinking the issue may be that we do not have an account with the Azure Data Lake for the Common Data Model.
Hi Jack2of3,
What type of connection are you worked? On-premise or online? (e.g. on-premise: SQL server installed in local device or VM, online: Azure SQL)
If you are working with a report that contains multiple connection modes with advanced operations, it may cause the issue to verify the credentials.
Regards,
Xiaoxin Sheng