Club Power BI

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  Performance probleme of power bi

    Posted 23 days ago
    Edited by Hanae Tahri 23 days ago
    I am currently working on a project to set up dashboards on Power BI, the model is simple, a single large table is imported to power BI which contains all the main indicators and the axes of analysis, other measurements are shouted in Power BI. And another table of less volume.
    I'm starting to have performance problems especially with the power bi desktop given the size of the table (around 17 M lines) (memory problem, latency ..).
    • Can having a cube and a live connection instead of import solve this performance problem?
    • What are the best practices ?

    Thanks for your help

    Hanae Tahri

  • 2.  RE: Performance probleme of power bi

    Top Contributor
    Posted 20 days ago

    The best practice is to avoid having a single big table in Power BI ;) You need a nice star schema with at least a date table and your data. 17 million is not a big deal for Power BI even with iterative functions like a RANKX it should work and it should be fast.

    All your axes of analysis should be put in dimension tables instead of the big table.

    If you put the column name (and if it is easy to understand, my English is not very good!), I can help you to create your star schema.

    Have a nice day,

    Jonathan CHANAL
    Chef de Projet Digital / Data Analyst
    MCSA Power BI & Excel