Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
10 | |
3 | |
3 | |
3 | |
2 |