Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 sharepoint list, with the same columns, etc. All good.
But this sharepoint list is filled with an APP that is in testing and, of course, the data is wrong, it bends, etc.
Can I remove it from indexing without it hurting me all out?
Thank you in advance
Solved! Go to Solution.
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,
Hi @Syndicate_Admin ,
Just wanted to check if you have resolved the issue?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
Hi @Syndicate_Admin ,
Just wanted to check if you have resolved the issue?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
Hi @Syndicate_Admin ,
Just wanted to check if you have resolved the issue or you still need any assistance?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You for reaching out to Microsoft Community Forum
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,
Ok, thank you very much. I'm going to try it, removing the references is where I see the "question kit". If I have any problem I tell you.
Thank you again
User | Count |
---|---|
85 | |
73 | |
52 | |
50 | |
46 |
User | Count |
---|---|
74 | |
58 | |
50 | |
47 | |
41 |