question

ovonemty avatar image
0 Votes"
ovonemty asked LukasYu-msft commented

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

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
image.png (11.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

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


image.png (25.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Should this solve your issue ? Any feedback is welcome !

0 Votes 0 ·