Forum Discussion

hi_world's avatar
hi_world
Icon for Helper III rankHelper III
3 years ago
Solved

modifying the model becomes very long

Hello, 

 

i'm creating a dataset on powerbi desktop connecting direct query on gcp. 

modifying the model becomes very long (create a new column for example...)

 

do you know how to improve the performance of power bi desktop ? 

 

i have 16 gigabytes of ram

 

Best regards

  • hi_world , in the version it gives the option to stop the visual refresh when you are creating measure/column so that it does not load it

    Pause visual under optimize

     

     

    Increase data cache

    Go to File-> Options and settings -> Options -> Data load

     

    Avoid bi-directional joins

2 Replies

  • hi_world , in the version it gives the option to stop the visual refresh when you are creating measure/column so that it does not load it

    Pause visual under optimize

     

     

    Increase data cache

    Go to File-> Options and settings -> Options -> Data load

     

    Avoid bi-directional joins

  • Hello amitchandak 

    Thanks for answering !

     

    It is intereting for creating visualization. 

    But i still have a problem when for example i need to group by some fields in group name (display folder) in model view. 

    Is there a way to improve performance of this part. i heared that using tabular editor is more faster. what do you think ? 


    Best regards