Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi @v-juanli-msft ,
This is in continuation to the solution you provided for my post:
your code worked well when we have a small data.
I now added the similar other critierias in the same code which went really very long since we have multiple criterias in this. I now get this Memory error:
Since my Material type is alwasys going to be ZHWA, can we have it common somewhere instead of repeating it several times.?
I believe this should solve the memory error.
Or any other alternative would be greatly appreacited!
Thanks,
Tejaswi
Solved! Go to Solution.
@Anonymous
You may take a look at the links below.
@Anonymous
You may take a look at the links below.
Hi @v-chuncz-msft ,
These documents are indeed very helpful.
Using Var function resolved my memory issue.
Thanks,
Tejaswi
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 153 | |
| 130 | |
| 111 | |
| 79 | |
| 54 |