Forum Discussion

whatever610's avatar
whatever610
New Member
2 years ago
Solved

How to delete Semantic models?

I am a bit confused.. On PowerBI service, I created a semantic model from an excel file by a manual upload, now this option is gone.

I created another one with a manual copy-paste, now I cannot delete any of the two semantic models.

 

How do I simply delete a semantic model??

3 Replies

  • whatever610 

    In Power BI service, deleting a semantic model can be a bit tricky because there isn't a direct option to delete it like other objects such as reports or datasets. However, you can delete a semantic model by following these steps:

    1. Navigate to the workspace where the semantic model is located.
    2. Go to the "Datasets" tab.
    3. Find the dataset associated with the semantic model you want to delete.
    4. Click on the ellipsis (...) next to the dataset name.
    5. From the dropdown menu, select "Settings".
    6. In the dataset settings, scroll down to the "Data source credentials" section.
    7. Click on "Edit credentials".
    8. In the data source settings, click on "Switch to direct query".
    9. Confirm the change to direct query mode.
    10. Once the dataset is in direct query mode, it will no longer be associated with the semantic model, and you should be able to delete the semantic model.

    Keep in mind that switching to direct query mode may have implications for your reports and queries, so make sure to review and test your reports after making this change.

    After you have deleted the semantic model, you can switch the dataset back to import mode if needed by following similar steps and selecting "Switch to import mode" instead of "Switch to direct query".


    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi whatever610 ,

     

    The most straightforward way to remove a semantic model from the Power BI service is to select the corresponding semantic model in workspace and right-click on the delete option.

    Note: When you delete a semantic model, Power BI Services also deletes all reports and dashboard tiles that use data from the semantic model.

     

    For more details, you can refer to below document:

    Tutorial: Get started creating in the Power BI service - Power BI | Microsoft Learn

    Semantic models in the Power BI service - Power BI | Microsoft Learn

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.