Forum Discussion
Performance issues PowerBi embedded
Hi,
I've embedded several PowerBi reports over the last months. Those reports are embedded and stored in a PowerBi workspace collection in Azure. Over the last months the number of users of those reports increased. In the beginning there were only 15 people using those reports, but now it's about 60 (and still growing). The problem that I have right now is that sometimes the reports are really fast and that the report is build in 1 maybe 2 seconds. But I also have situation where it takes up to 20 maybe 30 seconds before an report is build.
Does PowerBi embedded run queries one after another? Sometimes I get the idea that I have to wait with clicking again till an selection is executed completely, that's even when just one person is checking the reports - not even talking about all 60 employees. Is there an option to improve this? Does PowerBi embedded only handle queries one after another or can he run multiple (is it an setting)? Does moving to another subscription maybe help? So moving from Azure SQL server Standard to Premium?
Could somebody help me with this?
Super UserHi TJacobs
Just a few questions.
- Which SKU of Power BI Embedded are you using?
- Are all the users using the reports at the same time?
- Are any of the reports using Row Level Security?
- When you are referring to Azure SQL Server standard, do you mean Azure SQL Database, or using the Power BI Embedded SKU within Azure?
From what it sounds like to me, is due to the changes in terms of the capacity requirements for Power BI Embedded as your users have grown, you are hitting the capacity limit for your current Power BI Embedded SKU.
My blog post here has more details around the different options: https://www.fourmoo.com/tag/power-bi-embedded/
HI GilbertQ
1: I'm using Power BI Workspace Collection in Azure for the embedment of the reports... is this scaleable?
2: Could be, the reports are embedded in an portal with Azure PowerBi embedded. So users could use the reports at the same time.
3: Not yet, the current users can see the whole report - but there are some requests to work with Row Level Security, so I'm preparing that.
4: Yes, that's what I meant. I was using Azure SQL Database - pricing tier S7 Standard 800 DTU, but I've never hit the 800 DTU and still had the problems with my slow reports. Last week's thursday I've tried P2 (premium 250 DTU), I did hit the maximum of DTU's and it wasn't faster then the S7.