Forum Discussion

jaryszek's avatar
jaryszek
Super User
10 months ago
Solved

Error fetching data

Hello, I got : report was working yestarday, today I can not open anything beacuse i have not loaded visuals.  What to do?  DataSet is OneLake dataset.  Best, Jacek
Need Help
  • v-achippa's avatar
    v-achippa
    10 months ago

    Hi jaryszek,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Your dataset query is failing because it needs more memory i.e 38 GB than the current workspace capacity allows only 25 GB limit.

    • Please move the workspace to a Fabric or Premium capacity with higher memory limits, or scale up your existing capacity.
    • If not you will need to reduce the dataset size like for example by removing unused columns or enabling incremental refresh.

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
10 months ago

Hi jaryszek,

 

Since this is a OneLake(DirectLake) semantic model, you can’t see table sizes in Vertipaq Analyzer like the Import models.

  • To check model size, look at the underlying lakehouse or warehouse tables, their row counts and file sizes reflect the semantic model size.
  • To find which query or measure is causing issues, use Performance Analyzer in power bi desktop to see which visual or query runs long and check the Fabric Capacity Metrics app for any memory spikes.
  • Your % of Total Quantity measure with ALLSELECTED can scan the entire fact table, which can cause the memory spike. Try testing with filters or try replacing ALLSELECTED with a lighter one.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
10 months ago

Hi jaryszek,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa