Forum Discussion

vejas's avatar
vejas
Helper I
7 years ago
Solved

Data model best practice

Hi,        Which way better:  -  create one big data model with multiple fact tables - purchase, sales, inventory, general ledger and dimensions (all main sql tables used by ERP)  and create Power...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi vejas 

    it is not just matters of perfomance.

    When you have too large data in a Pbix file, it may not support to publish the report to web side.

    Thus you could not share Power BI reports to more people.

    Also, with a correct and good model, it is much easier to create calcuated columns/measures so that it is simple to create proper visuals.

     

    Best Regards

    Maggie

     

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

vejas's avatar
vejas
Helper I
7 years ago

so it just matters of perfomance ?

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi vejas 

it is not just matters of perfomance.

When you have too large data in a Pbix file, it may not support to publish the report to web side.

Thus you could not share Power BI reports to more people.

Also, with a correct and good model, it is much easier to create calcuated columns/measures so that it is simple to create proper visuals.

 

Best Regards

Maggie

 

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