Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is it possible to extract metadata information about which sql tables and fields, that are used in published Power BI datasets using the Power BI REST API? I have only found out to get information about the datasources and databases using the GetDatasourcesAsAdmin.
Br.,
Thomas
Solved! Go to Solution.
Did you consider my earlier response? That will give you what you need.
which sql tables and fields, that are used
Please define what you mean by "used".
Anyway, have a look at how to run DMVs against your datasets.
select * from $SYSTEM.TMSCHEMA_PARTITIONS
select * from $SYSTEM.TMSCHEMA_EXPRESSIONS
Also note that the new Scanner API can do the same on a tenant level.
Hi,
So we have a bunch of datasets (pbix files) that are published to the Power BI service. We would like to monitor which databases, tables and fields/columns that each dataset connects to on our SQL server.
Did you consider my earlier response? That will give you what you need.
oh did only check out the DMVs, but the scanner API looks really promising. Thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |