Forum Discussion

lg01's avatar
lg01
Advocate III
1 year ago

Modify Semantic Model created from Sharepoint

I have a list in Sharepoint and we added it to PowerBI to analyze its data. I did not create the powerbi file; but I am told it was created using the Integration tool in Sharepoint and then selecting...
Need Help
raishubham955's avatar
raishubham955
New Member
1 year ago

No, Semantic Models created via SharePoint's Power BI Integration cannot be directly modified in Power BI Service or Desktop. These models are auto-generated and locked for changes.

However, you can work around this by:

Solution 1: Rebuild the Report in Power BI Desktop

  1. Go to Power BI Service → Open the report.
  2. Click More options (three dots) → Export → Power BI (PBIX) File.
    • If this option is disabled, SharePoint-generated datasets do not allow exporting.
  3. Open the exported PBIX file in Power BI Desktop.
  4. Click Transform Data → Load the SharePoint list manually via SharePoint Online Connector.
  5. Include the lookup table and create a relationship.