Search code examples
visual-studiossasbusiness-intelligencessas-tabular

Finding source of data in SSAS tabular


I have the following table in SSAS tabular using visual studio.

I would like to find out what source table Customer name uses as it seems to be using a wrong table, but I can't figure out how to find out which table it uses from.

my SSAS table

picture of property window


Solution

  • View the properties window. To display this, highlight the table in SSDT then go to View > Properties Window or press F4. After this, find the Source Data field and click the ellipsis next to it. This will open a window that will display either the source table/view, stored procedure EXEC statement, or SQL command that the table is derived from.