Forum Discussion

TJacobs's avatar
TJacobs
Frequent Visitor
8 years ago

Performance issues PowerBi embedded

Hi,    I'm having some performance issues with PowerBi embedded, this is the case:   I have added 5 reports to our own internal portal, the reports in this portal are added with PowerBi embedded....
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

Hi 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/

TJacobs's avatar
TJacobs
Frequent Visitor
8 years ago

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.