In tabular model, how to convert a sql code consumption to a full consumption of the table?

ovonemty 56 Reputation points
2021-06-24T11:28:57.327+00:00

I have a tabular model... and I have this table with a very simple query:

108994-image.png

Is there a way to convert this query (which is just a select *) to a "full consumption", that is, when instead of the sql statament the table is directly displayed?

I know I can add a new table and do it, but the table has lots of calculated columns, so I would rather do it by changing the existing table

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,247 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-06-25T06:58:41.903+00:00

    Hi,

    I guess you want to preview the table the the table property window, right ?

    You could click the "Switch to" in you screenshot and choose "To Preview" as following, then you could see the table instead of query:
    109321-image.png

    Regards,
    Lukas