The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello All,
I’ve created several dashboards that refresh daily, using multiple data sources that include a SharePoint list as well to generate charts. I’ve been asked to delete 10 out of 25 columns as part of data cleansing from this SharePoint list. These 10 columns aren’t used in any of the Power BI dashboards, but I’m concerned that deleting them might affect the daily refresh. Could you suggest the best way to delete these columns without impacting the daily refresh?
Thanks in advance.
There are multiple ways to skin a cat, but probably the easiest is just edit the query of the table when in the PBI Data Model View. This will bring up the PowerQuery editor, you can select the columns you want to keep and Remove Other Columns. Save query and your done! It shouldn't affect the daily refresh.
Hi @h11
To safely delete the 10 unused columns from the SharePoint list without impacting the daily refresh, follow these steps:
Check in Power Query:
Open the Power Query editor in Power BI and review the steps applied to the SharePoint list. Specifically, check if any of these 10 columns are being referenced in any of the transformation steps.
Ensure the columns are not key components:
Verify that the columns are not used as:
Adjust Power Query steps if needed:
If the columns are referenced in any transformation steps, update or remove those steps to eliminate dependency on the columns before deleting them in SharePoint.
Test the refresh:
After making these changes in Power Query, test the refresh in Power BI Desktop to ensure it completes successfully. Then, test the refresh in the Power BI Service before finalizing the deletion.
If the columns are not referenced in Power Query or used as keys/measures, deleting them should not affect the daily refresh or the functionality of your dashboards.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.