Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
User | Count |
---|---|
18 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
23 | |
4 | |
3 | |
2 | |
1 |