Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago
Solved

Delete Indexed Data Source

Good afternoon. Let's see if you can help me. Maybe it's not very complicated but I don't want to touch anything without being a little sure. I have several indexed Excel tables. Then I indexed a...
  • DataNinja777's avatar
    1 year ago

    Hi Syndicate_Admin ,

     

    Yes, you can remove the SharePoint list from your data model without breaking everything—as long as you're careful. If you're using Power BI or Excel with Power Query, go into the query editor and locate the query that pulls from the SharePoint list. From there, you can either delete the query entirely or simply disable it from loading into the data model. If that SharePoint list was merged or appended with your other Excel tables, you'll need to update or remove those references to avoid errors. Just make sure nothing downstream—like calculated columns, measures, pivot tables, or visuals—is depending on it. If you're dealing with SharePoint search indexing rather than Power Query, removing it from indexing won’t corrupt your data model; it just affects visibility in search results. The key here is to trace how and where the SharePoint list is connected, then surgically remove it rather than yanking it out blindly. As long as you take those precautions, you’ll be fine—and your test app can go on misbehaving in peace without polluting your reports.

     

    Best regards,