Forum Discussion

ERing's avatar
ERing
Post Partisan
2 years ago

How can I make changes to a shared semantic model (dataset)?

I'm working on a report that was built by a previous developer. The report uses a shared semantic model (dataset). It seems we may have a need to modify a query being used in the semantic model, but I can't seem to find a way to even view the query that was written to bring in this data.

I'm an admin in the workspace, so I believe I should have any required permissions. Please help!


Need Help

7 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi ERing 

     

    You should be able to get a copy of the PBIX file from the previous developer. Hopefully that was stored in a central location. If you cannot get the PBIX file then you might be able to connect to the semantic model if you are using power BI premium or power BI premium per user via the XML a endpoint.

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    Hi ERing 

    Simply download the pbix and edit it in your desktop. best way to visualize the queries applied and DAX measures in the semantic model is by using Power BI Desktop.

     

  • ERing's avatar
    ERing
    Post Partisan
    2 years ago

    aj1973 GilbertQ Even with the PBIX, i'm still unable to see anything.

    I see this in the bottom right when I open the PBIX.

     


     

     

    So I select "Make changes to this model" and it pops up a screen with the list of all the tables in the model.

     

     

    So I select "Submit" and it changes the local PBIX on desktop to a Direct Query connection.

     

     

    I select "Transform Data" to open Power Query and it opens, however it shows "Queries [0]".

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      You can't edit a live connection tables.

      • ERing's avatar
        ERing
        Post Partisan
        2 years ago

        Isn't that the purpose of converting the local PBIX to Direct Query? If not, how do I overcome the live connection so I can make changes if required.

        For example, I know one of tables in my model is created using a native query. What would I do if I neeed to adjust that query?