Forum Discussion
Solved
Using Power BI REST API to get list of used tables and fields
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 informa...
Did you consider my earlier response? That will give you what you need.
which sql tables and fields, that are usedPlease 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!