Forum Discussion

dommyw277's avatar
dommyw277
Helper V
8 months ago
Solved

Connecting 2 semantic models through an api

We have a new api and i can connect to a semantic model i need to however when i try to connect to another semantic model i cant go up a level to find the other tables. I definitely have permissions to both as I have created 2 reports and can see them on each just not together. 

Need Help
  • dommyw277's avatar
    dommyw277
    8 months ago

    issue is with the database unfortunately so the solutions dont help this time through no fault of yours but i apprecaite the help always

6 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    8 months ago

    Hi, if you want to connect to two semantic models you can try one of the following ideas:
    - Creating a composite model. Connect to one of them as live connection and transform it as direct query to connect another one. You can read about that here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

    - If you have capacity (premium or fabric) you can copy the xmla endpoint and use analysis services connector to pick what you need.

    - Use power bi rest api to get data using dax query to the model. There are limit of rows and it doesn't work with rls.

    The first one is the easier and fast to configure.

    I hope that helps,

  • lbendlin's avatar
    lbendlin
    Super User
    8 months ago
    I definitely have permissions to both as I have created 2 reports

    That may not be sufficient. Do you have "Build" access to the other semantic model?

    • v-menakakota's avatar
      v-menakakota
      Community Support
      8 months ago

      Hi dommyw277 ,

      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank  ibarrau  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

       

       

      Best Regards, 
      Community Support Team  

      • v-menakakota's avatar
        v-menakakota
        Community Support
        8 months ago

        Hi dommyw277 ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

         

         

        Best Regards, 
        Community Support Team

  • dommyw277's avatar
    dommyw277
    Helper V
    8 months ago

    issue is with the database unfortunately so the solutions dont help this time through no fault of yours but i apprecaite the help always

    • v-menakakota's avatar
      v-menakakota
      Community Support
      8 months ago

      Hi dommyw277 ,
      Thank you for the update. Please continue to use the Fabric Community Forum.

      Best Regards, 
      Community Support Team.