Hi Celia, thanks for your videos, very informative, quick question, do you know how to obtain the LOCAL Name on instead of the Sharepoint URL when files are stored in Onedrive?
it works nice for files on my hd, but I m facing troubles doing this with files saved in onedrive and also with folders on my hd. any solutions for this?
Do you mean create a name range? Power Query can read named ranges. If you have a way to make the name value to update dynamically, it should work. I never tested that. Let us know what you find about this.
Hi, Matt! My apologies for only now having noticed your contribution through Super Thanks. SUPER THANKS TO YOU! Seeing this type of recognition means a lot to me because it shows that the tutorial was valuable enough to make you take the time to send monetary compensation. 🙏 You made my day! 😊
Great material, what if I have a group of Share Point Links, same structure, that I want to bring all in, all in the same folder, but there are other files in the folder I don't want to bring in
Once connected to the folder, you get the list of all the files in it. Click transform and then use the filter buttons in the columns with the file name and/or the column with the file path to create a rule that tells Power Query which files you want to bring or leave out of your data importation.
Thanks for your videos. I receive the following error: Expression.error: The field content of the record wasnt found. Details: Content=[table] Name=DataPath The name of the box is correct I need help. Thanks
Make sure you use the exact code I have for Source0 step. Only the name given to the cell should be different. I suspect you have "table" in your code instead of "Column1".
@@CeliaAlvesSolveExcel now it's ok. I dont know where exactly was the mistake, i copied the entire line and paste it and works fine. Thanks for your time, i appreciate it.
Hello! Wonderful video, thank you! Question, is there a way to adapt this method to dynamically reference excel files stored on SharePoint, without using power query. For contrast, we can use INDIRECT to dynamically create the file path, file name, and worksheet name to use for a cell reference for local files. You mentioned this constraint @1:13:30. Can you make any recommendations please? Again, thank you! Very useful techniques and I appreciate your teaching style!
Hi! Thank you so much for this video! Would it still work if the name of your path is in a different workbook? Excel.CurrentWorkbook(){[Name="Named_Range"]}[Content][Column1]{0} the Mcode says currentworkbook is it possible to reference to a different workbook?
Do you mean the name of the workbook with the data is in another workbook? If that's the case. Import that information with Power Query using Data > Get Data > from Excel workbook. Load as a table. Name the cell that receives the workbook name. Then use that cell name in the code explained in the video. Hope this helps.
There's good information here but it takes forever to get to the point. The first 25 minutes could have been condensed to 2 to 3 minutes. It's tough to follow.
Its a shame that this approach doesn't work for files stored in SharePoint. PowerQuery will return a Path as a URL but when you try to use that Path to return other files in the folder PowerQuery says the URL isn't an absolute Path.
To use that path (url) with Power Query you need to do Connect to SharePoint folder. But there's more to it. You cannot use the path as is and then there's a couple more steps.
I've been looking for this solution for a while as I wanted to use something similar to VBA's "ThisWorkbook.Path" on Power Query. Many thanks/muito obrigado, Celia!