Forum Discussion

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi PBInewbie21 - There is no automated way available to do this but if you should explore using external tools which are available and approved by Microsoft

    https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-external-tools

     

    These tools allow for analyzing the data model and looking at DAX and understanding the dependency on specific columns within your data model - you can refer to 16:30 in the below video

    https://www.youtube.com/watch?v=Jnyy1uhtbKo

     

    Hope that helps! 

    • PBInewbie21's avatar
      PBInewbie21
      Helper II
      5 years ago

      Thanks Sumanth for your reply.

      Problem here is we don't know which reports are using this column. I wish there was a way from Admin side to find out which report is pulling data from perticular table!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        hi PBInewbie21 - yes, unfortunately there is no straightforward way to idenitfy that. You can identify the datasource details by using the Lineage view to identify all reports that are accessing a particular datasource - that may be a starting point to identify the reports which may be potentially referecing the particular column in question

        Hope this helps!