Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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.
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.
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
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.
Check out the September 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.