Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
PBI got upgraded today from May 2022 to May 2023 Desktop (Report Server) and now I cannot open my previously developed reports which have fact tables (SQL Server) with rows in the millions.
The VM has16GB of ram and when I try to open a file it isn't going above 50%-60% but I get a error; Memory Allocation Error. I also tried creating a new report to load just the fact table in import mode with 57.6 Million rows and it kept failing at 18 Million I removed two columns (can't remove more and it isn't very wide) then after increasing the cache memory to 8192 (MB) it got to 47.8 Million before running out of memory. I also tried clearing the cache and increasing the maximum allowed.
I was expecting PBI newer versions to have better performance not worse. Any other suggestions?
Thanks
Solved! Go to Solution.
Hello @ringovski ,
if you didn't find a solution, you could reach out to microsoft support directly through this link https://support.powerbi.com
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Hello @ringovski ,
if you didn't find a solution, you could reach out to microsoft support directly through this link https://support.powerbi.com
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |