When I take customer name from dimension then my table visual performance is very slow.

[Raj2151]

I have a star schema with two facts and 4 dimensions, I have created a table view with fields and measures, when I drag customer name from dimension my table visual performace is too slow and sometimes I get visual exceed error. How to fix the performance issue.

[Anonymous]

Hi @Raj2151 

Has your problem been solved ? If it has been solved, please provide your method and then  consider Accept it as the solution to help the other members find it more quickly.

Best Regard

Community Support Team _ Ailsa Tao

[parry2k]

@Raj2151 I think we are not addressing the issue here. First I asked you to use one simple measure (I don't know what measure you are using, and if that is causing the performance) Can we stick to the basics as I described in my previous reply before you start using the measures. Maybe those measures are simple but I don't know and that's why I request to stick to the basics. 

[parry2k]

@Raj2151 doesn't make sense, how many customers are there?

Can you clarify, in a table visual, first drop a measure, let's say simply sum from one of the fact table and then drop customer, does it work fine? And now drop columns from other dimensions and see the performance.

Seems very odd that it performing very slow.

[Raj2151]

@parry2k  Thanks for your time I will address the issue myself. It will take some time.

[Raj2151]

@parry2k I tried by taking customer name first and then added all the measures it worked well. But when i dragged other field(Region) from geography dimension then it started taking time.

[parry2k]

@Raj2151 what is the relationship? You never answered that question?

[parry2k]

@Raj2151 there could be many reasons? Any relationship with cross filter direction to both? What are the measures?

✨ Follow us on LinkedIn and  to our YouTube channel

Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Raj2151]

@parry2k  It's Single direction one to many. Please see below snapshot of the model, 1st row has all the dimensions and 2nd row has two fact tables.

The table which is highlted in yellow is my customer table

[Raj2151]

@parry2k  Let me make it more simple, Even if i don't take measures in the table view then also the perfoamce is very slow.
For example lets say I am just dragging required fields from all the dimensions. As soon as i drag customer name from customer dimension then it starts spinning from long time. Looks to be there are so many customers in the table.
Can we do something on the power query side to improve the performance ?