Find powerBi reports dependent on given table

[RaviBellamkonda]

Hi, 

i have been tasked to identify all powerBi reports that are using a specific Snowflake table. Since original power Bi developer is not around and reports are across multiple warehouses.  I need a automated way to scan meta data of downloaded pbix files and list queries in each report so that I can do CTRL+F in text editor. 

Did anyone solve this usecase before?

Note: I have already tried calling Power API but getting error that the dataset is not a POST API. Also I cannot install any 3rd party tools since it needs approvals from security team and is A very long process. 

[lbendlin · Accepted solution]

The usual approach is to use the Scanner API or Purview.  If that is not an option for you then you need to connect to the semantic models individually and run DMV queries over the partitions.

select * from $SYSTEM.TMSCHEMA_PARTITIONS