Forum Discussion

vincetaylor's avatar
vincetaylor
Helper I
4 years ago
Solved

Add a new table to dataset

I am using a series of SharePoint lists that exist on a SharePoint site. as my data source. I previously used "Get Data" to add the lists as table to my dataset. A new SharePoint list has been added ...
Need Help
  • aj1973's avatar
    aj1973
    4 years ago

    vincetaylor 

    In Power Query the List 4 should be embeded in the navigation step. Click on the source step you will see 

    Try to find there and add it to the queries
    Before adding the List 4 copy/paste one of the Lists in the queries and then click on the Table to get it added to the Queries, Rename the new added Table

     

vincetaylor's avatar
vincetaylor
Helper I
4 years ago

Hi aj1973 
Refresh only refreshes existing tables. It does not import new lists. This is because when you use "get data", the system asks you to select which lists you want to import. From that point on, it only refreshes the data you selected initially. It never adds new tables. 

aj1973's avatar
aj1973
Community Champion
4 years ago

vincetaylor 

In Power Query the List 4 should be embeded in the navigation step. Click on the source step you will see 

Try to find there and add it to the queries
Before adding the List 4 copy/paste one of the Lists in the queries and then click on the Table to get it added to the Queries, Rename the new added Table