Share via

How to oraganize columns from 2 tables in 1 folder in SSAS Tabular Model

Swapnil 216 Reputation points
2020-10-08T15:50:23.38+00:00

Hi All,
I have 2 table sin Table 1 with 5 columns and Table 2 with 4 columns.
Now I wanted to have all the columns form table1 and table 2 to display in 1 folder /subfolders in Tabular Model

Display Folder property would make sure to display under same table but NOT in new folder.

Please guide

SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

0 comments
Answer accepted by question author
  1. Darren Gosbell 2,376 Reputation points
    2020-10-12T21:17:27.977+00:00

    What you are trying to do is not possible.

    Tables are the top level objects and you can only have folders under a table, so all the objects in a folder have to come from the one table.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,826 Reputation points
    2020-10-09T02:11:13.303+00:00

    Hi,

    How have you given the value for display folder property ?

    You could give "Folder1\Folder2" this value in it to get results like you want .

    Check this blog to see the outcome : SSAS – DISPLAY FOLDERS

    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.