Forum Discussion

tuckstar's avatar
tuckstar
Frequent Visitor
1 month ago
Solved

Cannot use composite model functionality (change your model)

I have connected a blank Power BI file to a semantic model on web service.  I want to add additional data from an Excel workbook.  The link which is supposed to enable the functionality (change your ...
Need Help
  • tuckstar's avatar
    tuckstar
    1 month ago

    Thanks everyone, figured it out with Claude.  The issue was that when I published the report I had published it into MY WORKSPACE.  In order for a semantic report to support a composite model, it has to be saved to a teams workspace.  

     

    I added a new workspace, published the base report to that space and then opened a blank project.  I connected to the team version and immediately have the MAKE CHANGES TO THE MODEL link.

DanieleUgoCopp's avatar
DanieleUgoCopp
Icon for Super User rankSuper User
1 month ago

Hello,
I am not completely sure why that button won't appear, but check that the Excel file is in the exact same workspace as your semantic model because mixing them often blocks the composite feature, also try connecting to the semantic model first in a brand new file before you bring in the Excel data, if that still fails just manually merge the queries in Power Query instead of waiting for that link to show up.

Best regards,
Daniele