pulling new columns from SharePoint List

For this explanation, I’m assuming you are using a SharePoint list as the data source in Power BI and have configured it as a component.

When you connect to a SharePoint list, Power BI imports both the data columns from the list and the associated SharePoint metadata columns. To work only with specific data columns, you may have applied a filter to select the necessary columns and exclude the rest. As a result, when new columns are added to the SharePoint list, Power BI does not automatically include them because it retains your previous selection of columns.

How to Fix the Issue:

1. Go to the Edit Queries section in Power BI:

   • Locate the table connected to the SharePoint list.
   • Right-click on the table and select Edit Query.

2. In the query editor, find the Applied Steps section on the right-hand side.

   1. 

       

3. Look for steps such as "Remove other columns" or "Remove columns":

   • Click the gear icon next to these steps to open the column selection settings.
   • 

      

4. In the column selection dialog, you’ll see a list of all available columns with checkboxes.

   • Find the newly added columns in the SharePoint list.
   • Check the boxes next to these columns.
   • 

      

5. Once done, click OK, then close and apply the changes.

This process ensures that the new columns are included in your dataset.

I hope this resolves your issue! If it does, kindly mark this as the answer. Let me know if you have further questions!