Find powerBi reports dependent on given table

RaviBellamkonda — Fri, 10 May 2024 04:48:52 GMT

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.

Re: Find powerBi reports dependent on given table

lbendlin — Fri, 10 May 2024 17:09:21 GMT

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

topic Find powerBi reports dependent on given table in Developer

Find powerBi reports dependent on given table

Re: Find powerBi reports dependent on given table