Dataset refresh in PowerBI Embedded workspace fails because it exceeds memory limit (5GB)
I have a dataset and a couple of dataflows in a PowerBI Embedded workspace. The dataflows serve as sources for the dataset. The reports connected to this dataset are embedded on our internal employee portal. Previously both dataset and dataflows were hosted in a PPU workspace, and all refreshes worked fine. However, the limited number of embed tokens ran out so I've had to switch it to an Embedded workspace. Now my dataset no longer refreshes because it exceeds the memory limit (we have the A2 SKU with 5GB memory and 2 v-cores) and it takes the dataflows about 5 times as long to refresh. The dataset is only 281MB in storage size, so I'm struggling to understand how it takes more than 5GB to refresh. To test I did temporarily up the memory limit to 25GB, which did allow refresh of the dataset. It is however not a feasible option to up the SKU permanently as it costs 10x more. Can someone help me understand why my model is pulling more than 5GB of memory for a refresh? And why my dataflows take 5x longer to refresh in the embedded workspace than in PPU workspace? Is there a way in which I can keep this data structure (dataflows and dataset running in PowerBI workspaces) and still embed my reports? Or do you have any suggestions for other options how to host my dataset (I've been looking at Azure data factory?) Thanks in advance!
How to securely embed reports or dashboards into application?
Hello Great Souls ! This is Alam here. I work as Lead Product Manager in a company name Nitex pte ltd. We are on a mission to transform the appreal industry and build the largest online design studio. As we are growing day by day we are using different tools and also building custom inhouse application to serve our customer and give them a seve star experience. Now we are also using power bi desktop to create different reports or dashboards and using the public URL to show them inside our in-house developed application. Now I know it is not the secure way of doing this. But the we have like more than 100+ users who need to see different reports and dashboards and its sort of exoensive for us at the moment to purchase power bi pro liscense for all of them. So is there any other way apart from using power bi pro liscense which will ensure the security of our data which are in different reports and dashboards? Would really appreciate if anyone can suggest a secure and proven way to embed these reports into our application without using power bi pro liscense. Thanks in advance S N Alam
