Dataflow Refresh Failure - SQL Server to Dataverse Table Using On Premise Gateway

[garrettmr]

Hello,

We have an on premise SQL server where we have many tables of data. We want to build apps using this data, and therefore want to load data from the SQL tables into Dataverse tables. We have an on premise gateway. We have built the connection, and built the dataflow such that it loads data into an existing table (I have tried loading into a new table as well but get the same error).

The dataflow successfully publishes but the refresh fails with the error: 

"There was a problem accessing your storage account or content. Please verify it's configured correctly and reachable and try again later."

I am not an admin of the data gateway, unfortunately it is owned by our IT group and I am just a shared user of the gateway.

Any ideas?

[miguel]

Is this for a Dataflow inside of PowerApps? Or a Dataflow in Fabric?

[garrettmr]

The dataflow is inside of power apps. It is supposed to pull data from an on prem SQL server and load into a table inside of a solution in power apps (if this is not the best way to do this let me know).

[miguel · Accepted solution]

I'd recommend posting your question in the PowerApps forum:

https://powerusers.microsoft.com/t5/Power-Query/bd-p/PA_PowerQuery

This forum is only for topics related to Dataflows inside of Microsoft Fabric.

[garrettmr]

Hello,

Unfortunately the refresh history doesn't provide any more detail. This dataflow has never refreshed successfully and it is the same error every single time.

And yes we are using the latest version of the gateway.

Still no luck at fixing this error.

Thanks

[v-cboorla-msft]

Hi @garrettmr 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

As I understand that the dataflow successfully publishes but the refresh fails with the error: 

"There was a problem accessing your storage account or content. Please verify it's configured correctly and reachable and try again later."

Try to view refresh history and monitor your dataflows:

Monitoring your dataflow refreshes is key in ensuring that your dataflows are running as expected. Refresh history and monitoring hub allows you to evaluate in detail what happened during the refresh of your dataflow. This article provides you with an overview of the features that are available in the refresh history and monitoring hub. We also provide you with some guidance on how to use these features.

For more details please refer : View refresh history and monitor your dataflows.

This might help you, If you are using Microsoft Fabric through an on-premises data gateway, be sure to update to the latest version of the gateway. This ensures that any updates to Fabric features and known issues are propagated through the gateway.

For details please refer : Currently supported monthly updates to the on-premises data gateways.

If the issue still persists, please do let us know. Glad to help.

I hope this information helps.

Thanks.