Forum Discussion

kalkhudary's avatar
kalkhudary
Helper IV
2 years ago
Solved

Data Model: Multiple Lookup Tables connected through Bridge Table

Hello everyone,  I am working on a data model that includes multiple Lookup tables that need to speak to each other in both directions. 1 - Applications ( App Id, Status, Division, Purpose) 2 - Se...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, kalkhudary 

    Your data model design sounds very well organized, especially by bridging the IDs of the individual lookup tables through a bridge table, which ensures bi-directional communication and consistency of the data.

     

    Here's a brief overview of the semantic model size limitations:

    • For Power BI Pro, the semantic models are capped at 1 GB.
    • For Power BI Premium P1, the limit is 10 GB per model.
    • For Power BI Premium F32, the limit is 10 GB per model.
    • For Power BI Premium F64, the limit is 25 GB per model.

    In addition, the maximum size of the semantic model can be up to 100 GB when using a Power BI Premium Per User (PPU) license.

    These limits are for each individual semantic model, not the sum of all models. Therefore, if you have multiple models, the size limit for each model is independent.

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, kalkhudary 

Your data model design sounds very well organized, especially by bridging the IDs of the individual lookup tables through a bridge table, which ensures bi-directional communication and consistency of the data.

 

Here's a brief overview of the semantic model size limitations:

  • For Power BI Pro, the semantic models are capped at 1 GB.
  • For Power BI Premium P1, the limit is 10 GB per model.
  • For Power BI Premium F32, the limit is 10 GB per model.
  • For Power BI Premium F64, the limit is 25 GB per model.

In addition, the maximum size of the semantic model can be up to 100 GB when using a Power BI Premium Per User (PPU) license.

These limits are for each individual semantic model, not the sum of all models. Therefore, if you have multiple models, the size limit for each model is independent.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.