How to Fix the DataSource.Error Message in Power Query

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[paspuggie]

I have to do this a lot Doug so I use a cell in Excel worksheet for the user to type in their path, which is then linked by creating a table then drill down. So the source references that path. Works a treat 😀

[DjehutimasAsarRa]

How can I do this for Folder.Files when I bring them all in as a folder?

[Rkeev]

Please cover urls as well like a holidays website that changes for 2022, or 23, etc

[DJGuriOfficial]

What if we create a data model and then a pivot using that data model.
Just share the file with the pivot (and not the data). Isn't it possible for the user to access the pivot without the source data file at their end?

[alanv]

I'm building an updating DCF model and I made it so that the user can input any ticker they want and it will get the data for it. The problem I experience is that when Excel gets the ticker from the user, for some reason Excel decides to slap on a %20 for no reason with the ticker and that results in a 404 error. How do I stop Excel from adding that %20 to my ticker?

[phanvanich]

hi sir. Can you help me to fix this erro in power query . I put in content"= Table.AddColumn(#"Removed Other Columns", "Custom", each excel.workbook([Content]))" but there is erro "Expression.Error: The name 'excel.workbook' wasn't recognized. Make sure it's spelled correctly."
please suggest me to fix this erro. many thanks