Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!