Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I've had a file in the service for quite a while now (over a year) and just recently I started getting the following error. I've made any big recent changes especially to the number of queries.
Thanks,
Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: 937a2912-c631-47ab-ab50-23ddb015c2c7
Request ID: cec4336a-bbe7-4d54-b7a8-39cf1cb30ddc
Time: 2020-05-20 14:03:40Z
Solved! Go to Solution.
Hi,
Hope these can help:
https://community.powerbi.com/t5/Service/Memory-error-Memory-Allocation-failure/td-p/229420
https://windowsreport.com/memory-error-allocation-failure/
Best Regards,
Giotto
My problem is with the Power BI service, not the desktop version, so I don't think the second one applies.
I've reviewed my queries, and I don't really have anything that complex. Not to mention they've been working for a while. The only new thing, is I do use summarizecolumns to create a inventory snapshot table.
I guess I could try removing that... But I kind of need it.
Ok, I have confirmed that it is a new created table causing the problem. But I confess I'm not that good with Power Query. The DAX I am using to create the table is
Inv Summary Col = SUMMARIZECOLUMNS('Item Value New'[Item Ledger Entry Quantity], 'Item Value New'[Posting Date],
"Bal Qty", CALCULATE(SUM('Item Value New'[Item Ledger Entry Quantity]), FILTER(ALL('Item Value New'[Posting Date]), 'Item Value New'[Posting Date]<=MAX('Item Value New'[Posting Date] ) ) ),
"Bal Cost", CALCULATE(SUM('Item Value New'[Cost Amount (Actual)]) , FILTER(ALL('Item Value New'[Posting Date]) , 'Item Value New'[Posting Date] <= MAX('Item Value New'[Posting Date] ) ) )
)
Can I do that in power query?
Ok, I will put learning power query after I'm done reading "The Definitive guide to Dax".
Thanks,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.