Forum Discussion
Best Practice for Editing Semantic Model
Hi Anonymous
It looks like you're connecting to a semantic model using live connection. This type of connection doesnt allow editing the model so changes to it other than creating new measures must be done in the model itself. For changes that do not require ETL, you will be able to edit the model in the service (if enabled by your tenant admin). For changes that requires the query editor, you will need to edit in Desktop and republish the model.
Should I edit in Power BI service directly and should I make a copy of the original semantic model?
Making a copy fo the original semantic model defeats the purpose of being able to create thin reports out of it. You will end up maintaining too many semantic models that serve the same purpose.
Should I only do the minimal transformation in PBI service (data type only) or should I also create columns and measures in PBI service? You can't do this with live connection so it is necessary to do the needed ETL in the semantic model itself and ideally as upstream as possible (at the source).
If you need to bring in more data but want to use the existing semantic models, you can connect to those using direct query. If initially using a live connection, adding another data source will prompt you to create a local copy of the model. RLS and permission from the referenced semantic model will still apply.
You’re welcome! Given your scenario, here are some steps you can follow to import data from the semantic model into Power BI Desktop:
Use Power BI Service Live Connection:
- In Power BI Desktop, go to Home > Get Data > Power Platform > Power BI datasets.
- Connect to your published semantic model in the Power BI service. This allows you to build reports using the data, relationships, and measures from the semantic model.
Workaround for Import Mode:
- If you need to work in import mode, you can use a workaround by connecting through the Analysis Services connector:
- In Power BI Desktop, go to Home > Get Data > Analysis Services.
- Enter the server address of your Power BI service workspace (this requires a premium capacity workspace).
- This method allows you to import tables from the semantic model.
- If you need to work in import mode, you can use a workaround by connecting through the Analysis Services connector:
Export to Excel and Import:
- Export the required tables from the Power BI service to Excel.
- In Power BI Desktop, use Get Data > Excel to import the tables.
These methods should help you manage and refresh your semantic model effectively in Power BI Desktop. If you have any more questions or need further assistance, feel free to ask!
Please also follow below link ... May it will help you.
Connect to and transform data for a semantic model – Tabular Editor Blog
Solved: Import Table from Power BI Semantic Model - Microsoft Fabric Community
Thanks for the explanation. The source is Power App RSS and the export options are limited, either to files or export to Power BI. I want to be able to refresh the semantic model, so that's why I choose to export to Power BI. In this case I only have the option of connecting through direct query. Is there a way where I can import the data from the semantic model to Power BI desktop?
You’re welcome! Given your scenario, here are some steps you can follow to import data from the semantic model into Power BI Desktop:
Use Power BI Service Live Connection:
- In Power BI Desktop, go to Home > Get Data > Power Platform > Power BI datasets.
- Connect to your published semantic model in the Power BI service. This allows you to build reports using the data, relationships, and measures from the semantic model.
Workaround for Import Mode:
- If you need to work in import mode, you can use a workaround by connecting through the Analysis Services connector:
- In Power BI Desktop, go to Home > Get Data > Analysis Services.
- Enter the server address of your Power BI service workspace (this requires a premium capacity workspace).
- This method allows you to import tables from the semantic model.
- If you need to work in import mode, you can use a workaround by connecting through the Analysis Services connector:
Export to Excel and Import:
- Export the required tables from the Power BI service to Excel.
- In Power BI Desktop, use Get Data > Excel to import the tables.
These methods should help you manage and refresh your semantic model effectively in Power BI Desktop. If you have any more questions or need further assistance, feel free to ask!
Please also follow below link ... May it will help you.
Connect to and transform data for a semantic model – Tabular Editor Blog
Solved: Import Table from Power BI Semantic Model - Microsoft Fabric Community