Restructuring Tabule Model in SSAS

Swapnil 216 Reputation points
2020-09-22T17:58:50.137+00:00

Hi Experts,
I am working on creating new SSAS models and designing power bi reports from them. For now I could connect through Power BI to Tabular Model created but need few suggestions:

  1. Can move the Columns in tabular model in different folder?
  2. Can I move all measures in Tabular Model in one folder named "Measures" , so that end users should see all measures at one place?
  3. Can I create filters in Tabular model and use those while designing reports so that less data loaded in Report?

If all above can be done please let me know steps to do the same

Thanks

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.
1,231 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-23T08:08:25.56+00:00

    Hi,

    I assume your are talking about the appearance in Excel pivot table.

    1. Can I move the Columns in tabular model in different folder?
    2. Can I move all measures in Tabular Model in one folder named "Measures" , so that end users should see all measures at one place?

    For these two requests, you could use Display folder property of SSAS. Check this article: Setting Display Folders in Analysis Services Tabular 2016

    1. Can I create filters in Tabular model and use those while designing reports so that less data loaded in Report?

    In the tabular design , you could click the little triangle in the column header to add the filter. Filter Data in a Table.
    Or you could in Power BI design page, you could add report filter, which I think is very useful. Add a filter to a report in Power BI

    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.


3 additional answers

Sort by: Most helpful
  1. Swapnil 216 Reputation points
    2020-09-25T20:08:13.733+00:00

    Hi LukasYu-msft
    I have tried changing Display Folder property for a column as "Filters", bit when I check the same on Power BI report it does not shows there?

    Any idea if i am missing anything here?

    0 comments No comments

  2. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-28T02:28:03.513+00:00

    Not sure what happens with PBIRS, could it be the cache or saved report? In the first link, it suggests that the property applies to PBI desktop. I am not familiar with PBIRS. Maybe we could try use pbi report through PBI desktop.

    0 comments No comments

  3. Swapnil 216 Reputation points
    2020-10-08T15:37:52.067+00:00

    Thanks it worked, Can i have columns form other tables copied to sub folder under different table?

    0 comments No comments