Cant add local table to Power BI dataset

[Anonymous]

Hello,

I am using a Power BI dataset created in my organization but I need to add one simple table thanks to which I can create new categories.

The problem is that after adding a table and changing the model type, I can't see it in the model view, but i can't even delete or change existing relations.

Any solutions?

[amitchandak · Accepted solution]

@Anonymous , There are only limited operations you can do in Direct query to dataset, not all direct query features are available 

refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services#considerations-and-limitations