Forum Discussion

clozano's avatar
clozano
Frequent Visitor
5 years ago

Services refresh issues - Not able to modeling the dataset - Memory error: Memory Allocation failure

I habe a problem with Power BI services refresh & measures tables.

Services is not able to modeling the dataset properly. Let me explain you how I get this conclusion:

 

I took one dataset and:

1- refresh it with power bi desktop: everything OK, it works

2- I publish it on my workspace, and sincronized from the services: Everything OK, it works

 

Now we start with my problem:

3- The same dataset & pbix file than point 1 & 2, but with the only following modification: I moved a measure from my sales table to a measures table and I create inside this measure table a folder. 

 

 

Now:

4- I refresh in my power Bi Desktop: Everything ok - it works,

5- I publish it in my workspace and I try to refresh and like a hour after, it crash. Publishing works but automatically, services try to refresh it and after 1 to 2 hours, it crash with this message: "There was an error when processing the data in the dataset".

Showing the details: 

Data source error:Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:2215c5d3-14c7-4ba7-b0be-37a9d983ff06
Request ID:41e953db-20d5-7420-0258-8a5262f22a54
Time:2020-12-15 01:11:39Z
 

Anybody else have this problem? I don't know how to solve this problem.

 

Thanks in advance for your help.

 

Regards

 

 

 

1 Reply