Purview: new type definition custimozed - schema like PowerBI dataset

Hi!

I have tried to create an entity type through the API with a schema like powerbi_dataset.

For this I have tried alternatives. For example, I have duplicated all the powerbi entity types and their relationships in order to get a type with a schema like the attached one.

I created them with special attention to the section “options[schemaElementsAttribute]” and it still does not have the schema shown with the dropdown option of tables/columns nor the name “Field name”.

Regards. User's image

PRADEEPCHEEKATLA-MSFT 84,051 Reputation points Microsoft Employee

2024-06-07T06:27:49.54+00:00

@Jesus Carmelo Alaez Fernandez - Thanks for the question and using MS Q&A platform.

It seems like you are trying to create a custom entity type in Microsoft Purview with a schema similar to Power BI dataset. However, it is not clear what specific issue you are facing. Could you please provide more information or clarify your question?
Jesus Carmelo Alaez Fernandez 0 Reputation points

2024-06-07T07:02:30.3433333+00:00

Thanks for the quick response.

I have tried to replicate the entity type that has the same schema display as a powerbi_dataset type. But I am not able to achieve it from the types definition. I am not able to see the dropdown that appears in the powerbi_dataset schema.

On the one hand, I am not able to replicate that in the schema the “Field name” column is displayed. When I create a schema based on the dataset-table-column relationships I can only see a field called “Column name”.

And on the other hand, I am not able to visualize the nested schema. Only by clicking on the table I get the pop-up of the table where I can see its schema.

To try to solve the problem, among other things, I have created a type “powerbi_dataset2”, “powerbi_table2” and “powerbi_column2”, replicating also the relations between these types to get the same schema. For this I have generated a json file with the definition of these types which are almost identical to the ones I am trying to replicate. I can only get a schema based on the dataset-table or table-column relationship. Attached is a screenshot.

In conclusion, I want to get an entity type that from a single view I can see the dataset-table-column schema.

Regards.
PRADEEPCHEEKATLA-MSFT 84,051 Reputation points Microsoft Employee

2024-06-10T05:12:08.2866667+00:00

@Jesus Carmelo Alaez Fernandez - Based on your explanation, it seems like you are trying to create a custom entity type in Microsoft Purview that has the same schema display as a Power BI dataset. However, you are facing some issues with replicating the schema and relationships.

Firstly, regarding the "Field name" column not being displayed, it is possible that the schema definition for your custom entity type is not configured correctly. You may need to check the schema definition and ensure that the "Field name" column is included in the schemaElementsAttribute section.

Secondly, regarding the nested schema not being displayed, it is possible that the schema definition for your custom entity type is not configured to include the nested schema. You may need to check the schema definition and ensure that the nested schema is included in the schemaElementsAttribute section.

Lastly, it is not clear what specific issue you are facing with the custom entity types "powerbi_dataset2", "powerbi_table2", and "powerbi_column2". Could you please provide more information or clarify your question?

In general, to create a custom entity type with a schema similar to Power BI dataset, you may need to carefully define the schema definition and relationships between the entities. You may also need to refer to the Power BI dataset schema and replicate it in your custom entity type schema.

I hope this helps! Let me know if you have any further questions.

1 answer

Jesus Carmelo Alaez Fernandez 0 Reputation points

2024-06-11T11:56:29.1+00:00

First of all, I really appreciate the responses. Thanks again.

The problem I am trying to solve is the creation of a custimized entity type that is displayed with the same format as the schema of the type already created by Purview “powerbi_dataset”.

I replicated the powerbi types involved in the powerbi dataset schema (powerbi_dataset, powerbi_table and powerbi_column) in order to obtain the same schema. To do this I copied the type definitions by renaming them (adding a number 2). I attach screenshots of the definition of their types.

The powerbi_dataset type has no relation to any schema type entity that can change the schema display. It is based on the relationship with powerbi_table and does not refer to the column “Field name”.

Loading these types, which are practically the same, the visualization is different, as shown in the screenshots.

If you need further information, please contact us.

Regards!
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

Purview: new type definition custimozed - schema like PowerBI dataset

1 answer