Forum Discussion
Combine PowerBI Semantic Model and local files
I have a semantic model previously published to the PowerBI Service.
I want to create a new report, use the semantic model but also add further data sources (excel in this case).
However, when I load the semantic model, I cannot add any further data source.
I can't change storage mode either, since there are no option for it.
What am I doing wrong? 🙂
You are not doing anything wrong. That is by design.
You have two major choices:
1) Start a new Power BI file and build your own semantic model from both the Excel sources and whatever tables you need from the one already deployed. You may be able to simply copy and paste the M code to bring in needed tables.
2) Extend the existing Semantic model and add the Excel files.
Hope that helps.
1 Reply
- ToddChitt
Super User
You are not doing anything wrong. That is by design.
You have two major choices:
1) Start a new Power BI file and build your own semantic model from both the Excel sources and whatever tables you need from the one already deployed. You may be able to simply copy and paste the M code to bring in needed tables.
2) Extend the existing Semantic model and add the Excel files.
Hope that helps.