How to export list of dependencies from a tabular cube?

ovonemty 56 Reputation points
2023-01-23T13:45:38.91+00:00

I have my cube already deployed:

User's image

I am looking to map the dependencies of the cube; that is, the name of tables / data objects being used in these cubes.

How can I output that list??

I would like to get the full list of all the sources like:

User's image

Azure Analysis Services
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.
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    2023-01-23T17:25:11.6266667+00:00

    Hey, The below link can help : [https://stackoverflow.com/questions/58373283/ssas-tabular-dmv-to-get-source-query-for-a-table

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.