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
Anonymous
Not applicable

Super slow powerBI report when creating a measure or calculated column

Hi all, 

I have read a few topics about the same issue here but none found the solution so far. Maybe some people here are new with new ideas... let's give it a try.

 

First of all, I'm not talking about DAX queries. They seem to be well optimized so far. I'm talking about the model and the time it takes to create a new measure, new column, change the data type etc... For me it takes about 5min for each step. Today it's almost impossible to work on my model.

Here are some specs of my model:
size: 170Mb, approx. 5 fact tables with more than 5 Millions rows each, one table with more than 10 Millions rows. A lot of dim tables (1 to many with one way filtering). They are all connected via a calendar table created in powerquery not a CALENDAR() function. A lot of measures. Almost no calculated colums, except for ragged hierarchy purpose on only one fact_table.

 

I tried almost everything I could:
No calculated columns
Relationship based on integer, not string
Reduced cardinality as much as possible
Reduced table size as much as possible

Do you have any idea? Is the number of measures the reason for bad report performance? two way filtering maybe? 

Help much appreciated.

12 REPLIES 12
Syndicate_Admin
Administrator
Administrator

I have the same problem. It's not a question of the machine, or the size of the data set. Any clues?

Anonymous
Not applicable

Hi all,
Is there a correlation between the report performance and the home table of a measure?
Said in an other way: Is it better to associate a measure to an empty table, a dim table or a fact table?

Anonymous
Not applicable

This would be a question to ask somebody on the PBI team. Try to ask on their blogs. Or ask people like Marco Russo, Alberto Ferrari, Matt Allington, Casper de Jonge...
Anonymous
Not applicable

You can try to locate the DAX Gurus on their website www.sqlbi.com. Matt has his own website and Casper has his own blog. Just google for it...
Anonymous
Not applicable

Hi @Anonymous 
Is there a specific channel or forum where I can contact them?
Thanks,

sirlanceohlott
Advocate III
Advocate III

Hey @Anonymous ,

 

How many pages, visuals per page & measures do you think you've got in this report?

 

I find these things usually have a bearing on the report itself when editing. 

 

Also, not sure the specs of your workstation, that could have an effect as well.

Anonymous
Not applicable

Hi @sirlanceohlott 
Approximatly 40 pages and 500 measures in the report. Zero calculated columns, removed all of them for a test.
DO you thin it's linked to the count of measures?

Hi @Anonymous,

 

How does the model perform if you filter your dataset to a smaller set?

you could always develop with a subset of data and then remove the filters when published.

 

see this link from Chris Webb

https://blog.crossjoin.co.uk/2020/05/24/limit-the-amount-of-data-you-work-with-in-power-bi-desktop-using-parameters-and-deployment-pipelines/

Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


Anonymous
Not applicable

@richbenmintz 

I tried to reduce the history of the Fact tables to one year instead of 25 years and it has no impact at all. Seems like th eissue is from something else.

Anonymous
Not applicable

I tried to removed all the reamining Calculated columns and it's not improving anything.

nvprasad
Solution Sage
Solution Sage

Hi,

 

My understanding from your question is there could not be any issue with PBIX file in terms of size & number of rows. Kindly check the CPU & Memory utilization of your system. If your use more memory and CPU PBIX work slow. 

 

If the above one is not an issue means, kindly re-install PowerBI and try.

 

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

Anonymous
Not applicable

Hi @nvprasad , thanks for your reply.

Already checked this, CPU stable at 35% and Memory stable at 54%. Took this measure when "working on it" is displayed.

My concern is not really about the number of rows but more about the number of measures in a report. Could this lead to a poor performance of the report?

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.