Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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. So I have a PowerBi workspace in Azure where I store my reports and my data.
Before the data gets in Azure it is collected with a stored procedure to an local database. After the stored procedure is done the table is being pushed to Azure.
The data and records that are used in the reports:
- Report A has 3.478.040 records and data (kb) = 5.564.880
- Report B has 342.612 records and data (kb) = 438.720
- Report C has 46.806 records and data (kb) = 62.424
- Report D has 861 records and data (kb) = 1.168
- Report F has 2.800.778 records and data (kb) = 3.731.552
The Azure database is using 110 gb of the 250 gb that is available and I'm using 800 DTU.
When I look at the DTU usage diagnostics in Azure the highest peak (over a week taken) is about 40%.
When I look at the CPU consumption in Azure the highest peak is about 30%.
Performance recommendations on Azure is turned on.
So it's not that the DTU, CPU or storage is running on it's max... Does somebody have a clue on this matter?
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?
Hi @TJacobs
Just a few questions.
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.
Forgot something very important to say in my previous post, about 70 people are using those reports (!) and I use about 10 slicers in every PowerBi report.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |