Forum Discussion
Add a new table to dataset
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 ok after looking at your code and re-reading your original description I am now very unclear about what you are trying to accomplish.
What is the output of this query? A single table? Or multiple tables? The SharePoint.Tables function being used seems that it would only return a single table of all the items from a single list. Are you looking for the items in a list, or a list of lists?
Please be as descriptive as possible about what you're trying to achieve.
HI Anonymous
I initially used Get Data to get data from SharePoint Lists that exist in a SharePoint site. I imported the 3 lists that existed at the time.
1. List-1
2. List-2
3. List-3.
After using Get Data, these lists were imported into PowerBI as 3 seperate tables.
1. Table-1
2. Table-2
3. Table-3.
Now a 4th List has been added to SharePoint.
4. List-4
I would like to import this 4th list into the Dataset as the fourth Table without changing the existing tables
4. Table-4
I can't use Get Data again because it will import all the lists again. I just want to add List-4 to my Dataset