Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
garrettmr
Frequent Visitor

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

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).

 

garrettmr_0-1709155171277.png

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?

1 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.

View solution in original post

5 REPLIES 5
miguel
Community Admin
Community Admin

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

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).

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
Frequent Visitor

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
Community Support
Community Support

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024 FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.