Forum Discussion

Alexussaurus's avatar
Alexussaurus
New Member
2 years ago
Solved

Connecting to Semantic Model and Data View

Hello all,   I have following case. We have a semantic model and different stakeholders which should be able to create reports based on the semnatic model. The semnatic model contains senstiive dat...
Data Protection
Need Help
  • pasgrave's avatar
    pasgrave
    2 years ago

    I've the same problem as yours. I found the solution : Use the function DAX in Power BI

    1. create new table

    2. Table = CALCULATETABLE('your semantic model')

     

    Then u can display or modify data in the new table.  

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello Alexussaurus ,

 

unfortunatelly no, when connecting to semantic model it won't show the data view.

 

what you might do is create a table visual for them to show the data that they might need.

  • Alexussaurus's avatar
    Alexussaurus
    New Member
    2 years ago

    Hi Idrissshatila ,

     

    we have a lot of tables hence it's not feasible but thanks for letting know. Unfortunately, Power BI even doesn't have the possibility to drag and drop fall fields from a table into a visual so you have to select each field separately....

    • Idrissshatila's avatar
      Idrissshatila
      Super User
      2 years ago

      Alexussaurus ,

       

      I see, but in the connecting to semantic model, they won't be able to see the data view, but they can see the table name and column names and measures on the right side of the report pane.