![]() ![]() On your original data source, click Advanced Editor.Your advanced editor should look like this: Copy the two lines under let and before in (the Source and Filtered Rows lines).If you happen to have other files inside of the folder you don't want to combine then you will want to filter it down even more. You should be left with just the files you are going to be cominbing. Filter the Folder Path to the folder where your files are located.Instead, you will see a column called Folder Path (found in the last column). This works a bit different than other connectors where you're not going to see sub-levels where files are inside folders. What you'll see is all of the files inside of your OneDrive. Now, create a whole new data source in Power BI using SharePoint Folder.To use SharePoint Folders we only need the link to include the primary location of the SharePoint so you'll want to delete the everything after your username.Start by taking the url from your OneDrive which can be done with the instructions before or you can right click on your OneDrive icon in file explorer then clicking View Online. ![]() I will make the asumption that you have a folder on your local drive which is the same as on OneDrive. For this you will use the SharePoint Folder connector. It's not going to be a simple modification to your exsiting source but do able. That will change the source path from your local file to OneDrive. =Excel.Workbook(Web.Contents(" "), null, true)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |