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!
Power BI Embedded report fail to export with slicer selection
The 'Embed to Customer' level of our application has a Power BI report embedded in it. Since there isn't a direct export option, we have made a different button using Export to file option to export the report. The report is currently exporting, but it is exporting with the default slicer selection. To fix this, we created a second filter selection box in the application, sent the report's parameters, applied the filter, and were able to export with the selected filter. Nevertheless, we are unable to apply some of the distinct slicers that we have. These embedding scenarios are very cost-effective for embedding the report, but they are also very confusing and complex. and there are no suitable guidelines available to make this task simple to accomplish. Is there any way to simplify these things by capturing the slicer selection automatically to get the Token export the report easily..? currently we have P1 Sku capacity. embedded for Customer scenario through Service Pricncipal. Thanks.Power Bi Embedded report issue
Hi , I have create one Power BI Report with SSAS cube datasource and publish it to the Power BI Services and it is working completely fine , but when I try to embedded the same using embedded URL I am getting error. Please find the Screen shot of error. When I click on see details Activity ID: 966a37d9-f88d-4671-a183-ec01650cf23e Request ID: 215ede7e-fe3e-44aa-a86d-f398d70f6af1 Correlation ID: 7b6f0e4f-168e-88e9-2e18-78a570bc6d0d Time: Thu Jun 01 2023 18:52:09 GMT+0530 (India Standard Time) Service version: 13.0.20772.75 Client version: 2305.4.14049-train Cluster URI: https://WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net Activity ID: 966a37d9-f88d-4671-a183-ec01650cf23e Request ID: 215ede7e-fe3e-44aa-a86d-f398d70f6af1 Time: Thu Jun 01 2023 18:52:09 GMT+0530 (India Standard Time) Service version: 13.0.20772.75 Client version: 2305.4.14049-train Cluster URI: https://WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net Can anyone help me out with this
Microsoft power bi for internal system without Azure
Hello I am working on a web application ASP.NET + SQL Server and I want to use Microsoft power bi embedded But I have a problem that the server on which the system is located does not have an Internet connection ( internal system) According to what I saw, the power bi supports that, but I could not reach the method could you please guide me to the steps that I should follow ? Note: everything is local (I mean, the database is on the server, but the server does not have internet) THANKS..
