edit-table-properties option in SSAS tabular model

ArunRaaman 996 Reputation points
2021-09-29T02:51:10.06+00:00

Hello There,

I encountered a situation where the switch to mode is disabled in edit table properties tab in SSAS tabular model as shown in the screenshot below; I notice this difference in comparison to a youtube video, where the edit-tab /window got more options.

Would anyone please help me understand what makes the difference with options and edit window?

136098-edit-table-properties-ssas-tabular-mode.png

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

2 answers

Sort by: Most helpful
  1. Darren Gosbell 2,376 Reputation points
    2021-09-29T03:04:55.557+00:00

    The screenshot from your project is using a modern or "structured" data source. The one from youtube is using an older legacy data source.

    You can read more about legacy data sources here https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource#specify-provider-data-sources-in-tabular-1400-and-higher-model-projects


  2. CarrinWu-MSFT 6,876 Reputation points
    2021-09-29T07:44:06.58+00:00

    Hi @ArunRaaman ,

    Thanks for your posting.

    Could you please check which version of Visual Studio do you use? Though I tested in my VS2017, I can switch to table preview. But I found a feedback about this issue, and there has a workaround can fix it. Please refer to this link.

    In addition, the first query which is in your VS is M code. For more information, please refer to this blog.

    Best regards,
    Carrin


    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.

    0 comments No comments

Your answer

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