Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ismailc
Helper III
Helper III

Improve PowerBI Apps Performance

Good day,

 

Please Help, i have roughly 5 apps that source is from pre-populated sql Data warehouse tables

The PBI Reports have 4-6 tabs with roughly 5million records (using May PBI Version)

 

The issue is when opening the reports or filtering the busy icon takes a while to load and try clicking one 1 graph then filetring by slicer further is even slower.

 

Is there ways i can visibly/drastically improve the performce for the users, i access via the sql server which has 120gb ram and it takes a while to load 😞

I feel that its a put off for the users when deep diving into data

 

regards 

3 REPLIES 3
lbendlin
Super User
Super User

lbendlin
Super User
Super User

Please provide more details.

 

- Have you used DAX Studio to optimize the measures?

- Have you used Power Query Optimizer to improve ETL performance?

- Have you used SQL Query Plan analyzer to fine tune your indexes and statistics?

Hi,

Thank You for assisting, the loading is pre-populated sql tables

its the user experience that is bad when slicing and filtering due the large volume of data in backend

 

this could help with the caclulations loading

Have you used DAX Studio to optimize the measures > where and how please?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors