Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
2 years ago

How adding a new warehouse table/view to an existing custom Power BI semantic model in Fabric

Hi,

in Fabric I've tried to use the available options to add a new warehouse table/view to an existing custom Power BI semantic model, in order to update the related Power BI report. A such operation it doesn't seem very simple.

Any helps to me, please? Thanks

5 Replies

  • pmscorca 

    Assuming your custom semantic model is in direct lake mode.

    If you want to add new tables/views from warehouse to an existing custom semantic model, then follow these steps

    1. Enable edit data model in power bi service option in workspace settings

    2. Hover over the dataset and click on three dots and click on 'Open data model' 

    3. You will find an option to manage tables, click on it and you will find all the tables avaraible in the warehosue select the tables/view and click on confirm. thats it

     

    if the storage mode is import then I would suggest you to open the pbix file form power bi desktop and add the new tables/view by connecting to the warehosue directly.

     



    Need Power BI consultation, hire me on UpWork .


    If the post helps please give a thumbs up



    If it solves your issue, please accept it as the solution to help the other members find it more quickly.




    Tharun



    • pmscorca's avatar
      pmscorca
      Icon for Post Prodigy rankPost Prodigy

      Hi,

      the Power BI option is already checked:

      When I select the existing custom semantic model and the Open data model option I cannot see any Edit tables voice in the menù. Thanks

      • tharunkumarRTK's avatar
        tharunkumarRTK
        Icon for Super User rankSuper User

        pmscorca 

         

        As I mentioned in my previous response, if the storage mode of you tables is not direct lake then you will not be able add new tables from service. Just check the storage mode from advances settings 

        for import mode datasets, open the pbix file from desktop and add new tables by connecting to the warehosue.

         



        Need Power BI consultation, hire me on UpWork .


        If the post helps please give a thumbs up



        If it solves your issue, please accept it as the solution to help the other members find it more quickly.




        Tharun