cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rsudireddy Visitor
Visitor

Power BI Performance

Hi , 

I have a power BI reports uses the imported data frrom MDX cube using a query. It have only 2 million records but it takes more than 20 mins to refresh and failes with time out error as we have 20 min limit on cube. 

 

What could be reason and solution please.

 

Thanks,

R

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Power BI Performance

Hi @Rsudireddy 

 

What about the refresh performance on the desktop? if the refresh works much faster than service, 

1. please kindly check your Gateway server, make sure that it has got enough memory, CPU and bandwidth to both the source data and Power BI service.

2. You should take into account that refresh also needs/consume part of the capacity you own.
Please check what else happening in the same time that takes over the capacity.
A solution could be to schedule the refresh in non-rush hours or queue the refreshes for the night.

3. Is there any advanced operation in your query tables?(e.g combine, append, reference other query, calculate with external query table, custom function)

 

If this is a case, it will cause additional cost on calculating with these reference queries.(each row will loop calculation with reference table, it will increase memory usage and calculation time)

 

Maybe you can try to use List.Buffer or table.Buffer to cache these reference query to memory to reduce additional resource spend.

 

Reference link:

How to Improve Query Reference performance for large tables

Use of Table.Buffer in references

 

Also the official documents Power BI performance best practices 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

2 REPLIES 2
Dobby_Libr3 Regular Visitor
Regular Visitor

Re: Power BI Performance

Hi @Rsudireddy  

 

Its always difficult to try and see without knowing the network infastructer. First thing would be to remove any columns you are not using and try to clean up your model. Is it your visuals that are taking along time to refresh or your data into the query editor? 

 

You could always look at the performance analyzer available from the view payne. there is also some documentation on getting best perfomance on Microsofts website. 

 

Also as a thought with 2 million records it may be worth investing in a staging database. 

Thanks 

Dobby Libr3

Community Support Team
Community Support Team

Re: Power BI Performance

Hi @Rsudireddy 

 

What about the refresh performance on the desktop? if the refresh works much faster than service, 

1. please kindly check your Gateway server, make sure that it has got enough memory, CPU and bandwidth to both the source data and Power BI service.

2. You should take into account that refresh also needs/consume part of the capacity you own.
Please check what else happening in the same time that takes over the capacity.
A solution could be to schedule the refresh in non-rush hours or queue the refreshes for the night.

3. Is there any advanced operation in your query tables?(e.g combine, append, reference other query, calculate with external query table, custom function)

 

If this is a case, it will cause additional cost on calculating with these reference queries.(each row will loop calculation with reference table, it will increase memory usage and calculation time)

 

Maybe you can try to use List.Buffer or table.Buffer to cache these reference query to memory to reduce additional resource spend.

 

Reference link:

How to Improve Query Reference performance for large tables

Use of Table.Buffer in references

 

Also the official documents Power BI performance best practices 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors