Forum Discussion

amolt's avatar
amolt
Resolver I
2 years ago
Solved

A problem has occurred accessing your storage account or content

Hello, 

I'm looking to do something relatively simple, recover data from a SQL Server On premise database.


The last error message I got was this one:
A problem has occurred accessing your storage account or content. Check that it is correctly configured and accessible, then try again later. (Request ID: 8e57de0b-a75b-49c3-bd0c-f37ccce01098).

Any ideas?

  • Hi amolt !

    Could you please share your ticket ID / service request ID with me so I can take a closer look at your case? You can post it here or send it privately to me over a direct message. I wonder what could be consuming so much and if perhaps there are opportunities of improvements at the query level.

     

    I will be marking this as resolved as the underlying issue is related to capacity and just resource consumption. Such resource consumptions depend on a number of factors beyond just the capacity as it also relies on your data source, the connector in use and the overall query or dataflow that was created. There are techniques in which you could stage the data first and perform the transformations afterwards, so we could privately explore those options that would work best for your specific case.

     

    Best!

16 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi everyone,

     

    After MANY hours with MS support working through the issue(s), I have confirmed that the issue is related to the capacity itself.

     

    First test I did was to move my worspaces back to the Trial Capacity, which resolved all issues (took about 2 minutes and I was able to load and see everything again).

     

    Then, through the Azure Portal, I created a NEW capacity (F8 like my old capacity) and I switched all my workspaces to use this new capacity, and everything is now working as expected.  (Make sure to Pause your old capacity to not be charged for it).

     

    The support person acknoledged that MS is working hard to fix some performance issues with the Fabric capacities, and this was a functional workaround (considering that the product is still in "Preview").

     

    Hope this helps others.

    • amolt's avatar
      amolt
      Resolver I

      Hi, 

      Thanks for your feedback.
      Although my capacity (F4) has now been paused for two days, I am still unable to generate a 19-line PDF report without triggering an error: "The visual element has exceeded the available resources". If even such a simple action isn't possible with an F4 capability, I wonder what the point of sizing is. It's useless.

      • Anonymous's avatar
        Anonymous
        Not applicable

        I agree there is a definite issue here!

        I am processing a total of 4 Gb of data, using a combination of dataflows (Gen2), pipelines and Notebooks - with 3 lakehouses and 1 warehouse.

         

        I am using an F8 capacity and after 24 hour on my new capacity, I am back on the same situation.  I had to revert to the Trial capacity again.

        If I really need a F64 capacity to process 4 GB of data, Fabric may not be a feasable option for us.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I just paused my fabric element on Azure, switched it back on and viola. All working again.

      Thanks!

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee

    Hi amolt 

     

    Sorry for the inconvenience. I have escalated this to our internal team and will definitely come back to you if I get an update. Please continue using Fabric Community for help regarding your queries.

     

    Appreciate your patience.

  • miguel's avatar
    miguel
    Community Admin

    Hi!

    When exactly did you get that error? was it during a refresh operation or during the authoring stage?

    What version of the gateway are you using? if possible, please check if you can update or make sure that you're using the latest version of the Gateway.

    • amolt's avatar
      amolt
      Resolver I

       

      I get this error during refresh of a Gen2 data flow

      Gateway : 3000.190.19 (September 2023)

       

      Additional information:
      Today, I still get the same error message. My lakehouse is unavailable. Here is the error message :

      OR 

       

       

       

      Lakehouse explorer : 

       

      Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable

    amolt did you get any resolution on this?  I am in the same situation.  Lakehouse is unavailable, Pipelines fail to load, Dataflows (Gen2) are throwing the error you mentionned.

    • amolt's avatar
      amolt
      Resolver I

      Hi Anonymous,
      I have no real resolution at the moment, but I think I have an idea of the cause.
      A few days ago I bought an F4 capacity and migrated some of my workspaces to this capacity. Since then, I've been having a multitude of problems which, it seems to me, are linked to overexploitation of the capacity.
      If I look at the Fabric Capacity Metrics report, I'm over 100% CU utilization. I think that's the cause of the problem.


      On the other hand, if this is the case, the consequences are significant, as all my workspaces are impacted, not just the one concerned by the processing that generated these spikes in utilization.
      Nevertheless, after a while (between 5 and 10 minutes) the lakes become available again.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Having the exact same issue, litreally every DFG2 is failing.

       

      Did you get a fix?