Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Dynamic Query path (Power Query)
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamic Query path (Power Query)

    Quote Originally Posted by billszysz View Post
    Matt, i want to be precise.
    When You move the file to the new location, and You will not open the file in the new location, then there is an old path to the folder in the file
    But i think, this is not this case
    Yes, that is what I would expect. If you open the file then it will update, but if you don’t then it won’t.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

  2. #12
    New Member
    Join Date
    Aug 2019
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamic Query path (Power Query)

    Hello Team,

    I am very new to this power query, I tried the above solution, but it is not working for me, can anyone suggest what i am doing wrong.
    I also don't where this changes I need to made, I got little bit idea form "bOunce" code, so I done changes by Clicking on Table -> Data -> From Table/Range -> In Applied Steps (under "Source")
    Below is the code I tried in Power Query:
    let
    Path = Excel.CurrentWorkbook(){[Name="FolderPath"]}[Content]{0}[Column1],
    Source = Excel.Workbook(File.Contents(Path & "CHS Library growth.log")),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Count", type text}, {"Time", type text}, {"Date", type text}})
    in
    #"Changed Type"

    It just shows code and nothing else when i press enter.
    I have put formula in column "A1" and renamed it form "A1" to "FolderPath" and by Table start from column "C" to "F"

    Thanks to advance

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •