Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How can report developers view the tabular model star schema?

We have a large tabular model that contains several star schemas. When our Power BI report developers connect to the SSAS tabular model data source in Power BI, all they can see is the tables. There is nothing that indicates what the relationship between the fact and dimension tables are.

How can we let the report developers see the relationship between the fact and dimension tables?

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    I didn't meet your problem, and my version is 2.87.923.0 64-bit (November 2020).

    Please update your Power BI Desktop.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    You need to use the ‘Connect live’ connection mode to connect to the model in SSAS, and then you will see your complete star model in Power BI.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      When I Connect Live to my SSAS tabular model, my Power BI only shows me the Report tab, not the Model tab.

       

      I am using Power BI Desktop (May 2020). Which version are you using?

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    I didn't meet your problem, and my version is 2.87.923.0 64-bit (November 2020).

    Please update your Power BI Desktop.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Has your problem been solved?

    Is the problem caused by the version?

     

    Best regards,
    Lionel Chen

    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
      5 years ago

      v-lionel-msft , Thanks for your reply. I am having trouble downloading and installing Power BI Desktop November 2020. Once I have installed that I will check.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I have installed Power BI Desktop November 2020, and it does indeed have the Model tab available.

        The default Model tab, All tables, showed an error "The all tables view has been disabled." This is due to the tabular model having more than 50 tables. This limit can be increased by creating and setting an environment variable called PBI_diagramTableThreshold.  I create this PBI_diagramTableThreshold environment variable and set it to 999, and the All tables Model tab did indeed display a model diagram of all the tables and their relationships.

         

        The Model tab also allows you to create another tab where you can drag and drop a fact table onto the page. You can then right-click the table on the diagram view and select "Add related tables". The diagram will then update to show all the dimension tables that have relationships to the fact table.

         

        Curious why this feature was not available in Power BI Desktop (May 2020)