Forum Discussion
Pbiuserr
Post Prodigy
Post ProdigyRetrive only accurate columns from Dax Studio
Hello
I query select * from $SYSTEM.DBSCHEMA_COLUMNS but I can see lot of LocalTable and column name starting with ROW or underscore. How to get rid of those and have only columns available in the model?
edit: is it possible to add like 10 rows of content for each column?
2 Replies
- amitchandak
Super User
Pbiuserr , Quite a few _ tables are created because of auto date time hierarchy. It is usually recommended not use that and turn it off
PbiuserrThanks. Unfortunately I just took over this tenant and I was not the one developing the project
Do you have any idea how to get a sample of column values into query in Dax Studio?
