Forum Discussion
Solved
Semantic Model
Hello, I have my own semantic model with tables and measures created. I want to use that in other reports but with option to: - edit table - add new meaures - add new columns - see tables in...
Hello !
Try to connect to the PBI semantic model viaSSMS using the XMLA endpoint to manage, query, or script the model. You can copy the workspace connection string from PBI workspace settings.
Hello Ania26
This is expected behavior when using an existing semantic model.
When you connect to a published semantic model (live connection):
- You can use existing tables and measures
- You cannot edit tables, add columns, or modify the model
- Tables cannot be viewed because the model is not in import mode
Possible solutions:
- Use DirectQuery and and Import Mode for Power BI datasets (composite model)
- Allows adding new measures and some calculated columns
- to add additional business logic in it.
- Download and edit the original PBIX
- If you need full control (tables, columns, relationships) or any transformation needed based on the requirement.
- Best practice
- Create a central (golden) semantic model with all common measures.
- Reuse it across reports to avoid duplication of Semantic models , just you need to call the same Semantic model in the report.
- Please make sure that tables should have some specific indentification for each report if its different .
- Use DirectQuery and and Import Mode for Power BI datasets (composite model)