Forum Discussion
Helper IUsing 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 information about the datasources and databases using the GetDatasourcesAsAdmin.
Br.,
Thomas
Did you consider my earlier response? That will give you what you need.
4 Replies
- lbendlin
Super User
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.
thodHi,
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.- lbendlin
Did you consider my earlier response? That will give you what you need.