Forum Discussion

Andre-SiS's avatar
Andre-SiS
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • ToddChitt's avatar
    ToddChitt
    1 year ago

    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.

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

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.