Forum Discussion
API Scanning Metadata
Hello
I'm trying to use the new feature of the API to receive table and columns names (Enhanced admin APIs responses with detailed metadata (currently in Preview)).
However, after following the instructions (setting up service principles with tenant rights , Metadata Scanning) and republishing my datasets, the results of GetScanResult is still empty for the tables field.
For reference, this is what the example in the documentation is showing. List of datasets, with repsective tables and column names. However, in my call, these fileds remain empty even after checking all the requirements and limitations.
"datasets": [
{
"id": "e7e8a355-e77b-4418-a7b8-ae5972fdaa03",
"name": "ExportB",
"tables": [
{
"name": "EIM",
"columns": [
{
"name": "RowNumber-2662979B-1795-4F74-8F37-6A1BA8059B61",
"dataType": "Int64",
"isHidden": true
}
],
Has anyone managed to get this feature to work? Can you help me with figuring out the issue?Thanks for your help
Hi Gilbert
Thanks for the hint. With the resource, I was able to find my mistake.
In the WorkspaceInfo post request, the optional parameter datasetSchema=true has to be set to then get a scanID that returns table and column names in the scanResult call.
Thank you again for the quick response!
3 Replies
Hi lps_pbi
I have not tried it yet, but the blog post from PowerBI.tips is certain to work if you want to give it a try?
Using the Power BI Scanner API to Manage Tenant's Entire Metadata -
Hi Gilbert
Thanks for the hint. With the resource, I was able to find my mistake.
In the WorkspaceInfo post request, the optional parameter datasetSchema=true has to be set to then get a scanID that returns table and column names in the scanResult call.
Thank you again for the quick response!
