Forum Discussion
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 to the site. How do I add this new list as a table to my dataset?
I am using PowerBI desktop. I would appreciate any help especially specific steps.
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
11 Replies
vincetaylor can you post the Power Query steps or code that was used initially? This is the code which will need to be adjusted to include your new list. It can be accessed from the "Transform data" button on the ribbon.
Hi Anonymous Thanks for your help.
Are you referring to the Applied steps? There are only 3 in my list
I initially used the "Get Data" command to get the data from SharePoint.
vincetaylor yes, I'm thinking specifically the "Navigation" step is what would need altered to include your new list.
By clicking the "gear" icon next to that step you can edit it.
