slow reports

3 Topics

Reports Slow to Load on ios Mobile App
Hi All, My organisation has power bi report server and are trying to roll out mobile usage of our reports. Our reports connect directly to our Analysis Services database so they require no data refresh. While testing the reports on our mobiles we've noticed that our reports are significantly slower on ios as compared to android. ios devices seems to be to refreshing data while android devices do not have this prompt appear. (ios refresh) After the refresh is first completed the reports then run much faster on ios (still slower than android but acceptable). Does anyone know if there's a way to turn off the refresh or have any other suggestions? Thanks in advance.
AnthonyX3
2 years ago Place Report Server
483Views
0likes
0Comments
Calculate Statement - Slow Table Load with many informations
Hi guys, I have created this measure (Measure1) that actually obtain the result I want to discover and gives not many problem in limited filter context like table with few rows. Measure1= CALCULATE( [Measure0], FILTER( 'Accounting', 'Accounting'[Fiscal Period] >= RELATED( 'Price Lists'[Fiscal Period] ) )) The problem comes when I add more information in the table report like customer, item, country etc. lead to a very slow loading. The expression within calculate is made by the following measure: Measure0 = SUMX ( FILTER ( 'Price Lists', 'Price Lists'[Old Price]> 0 ), IF ( [ASP] > [Old Price], ( [ASP] - [Old Price] ) * [Quantity], BLANK() )) From the Measure 0 I am creating a context where from the price list I am creating a table with only the values "old price" area greater than zero and then creating and then the if statement. The measure 1 is using the measure 0 only where is retrieving the fiscal period from the price list with related. Can someone help me maybe with a best practice to fix the formula? Really thank you in advance for your help, Regards, ES
Solved
emarome94
3 years ago Place DAX Commands and Tips
1.7KViews
0likes
5Comments
Power BI Report server Report is **bleep** Slow: Can we host JS, CSS and Map files from CDN?
Hi, We have deployed our Power BI Report server in london data center where we have deployed Power BI Report server in one large size VM. It is not in Azure Cloud. Now when user browse the blank page report it takes 1.5 minutes to render. Upon investigation I found that most of the time taken is due to JS files 1. /powerbi/libs/scripts/interact.min.js, 2. /powerbi/libs/scripts/powerbiportal.dependencies.bundle.js 3./powerbi/libs/scripts/powerbiportal.dependencies.externals.bundle.js 4./powerbi/libs/styles/powerbireportserverhost.bundle.css 5./powerbi/libs/scripts/powerbiportal.common.bundle.js 7./powerbi/libs/scripts/powerbiportal.explore.bundle.js 8./powerbi/libs/scripts/require.js 9./powerbi/libs/scripts/powerbireportserverhost.bundle.js 10./powerbi/libs/scripts/reportserverhost.js 11./powerbi/libs/scripts/globalize.js 12/powerbi/libs/scripts/globalize.cultures.js 13./powerbi/libs/styles/jquery-ui.min.css 14.https://az416426.vo.msecnd.net/scripts/a/ai.1.0.4.min.js 15./powerbi/libs/scripts/jquery-ui.js 16./powerbi/api/explore/resourcePackageItem/d0245eca-d40d-46ce-9dba-51942cf15095/SharedResources/BaseThemes%2FCY19SU06.json 17./powerbi/libs/scripts/resizeSensor.js and CSS files and they take longer then usual to load into the web page. IS there any way we can upload the JS and CSS files into CDN and browse the report to make it faster. Is your answer is YES then how and where we need to make changes in the scripts. Regards Rajaniesh
Anonymous
6 years ago Place Report Server
2.7KViews
0likes
4Comments