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

ovonemty 51 Reputation points

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


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

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points


    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: