Hi all,
I am new to the world of PowerQuery and am currently trying to create an automated dashboard. From my little research, I found a few tutorials suggesting to use PowerQuery Editor to source files dynamically.
Thus far, I have a folder path set up, and everytime I pull data from that path, it pulls up a file that I cant seem to locate or figure out what it is.
'.DS-Store': A few online threads said it had to with the excel type, but this FILE CANT BE SEEN, so I DONT UNDERSTAND how I could possibly change something that isnt there.
Screenshot of PowerQuery Editor:
Screenshot of Folder:
ANY AND ALL HELP WOULD BE MUCH APPRECIATED!
Thank you
I am new to the world of PowerQuery and am currently trying to create an automated dashboard. From my little research, I found a few tutorials suggesting to use PowerQuery Editor to source files dynamically.
Thus far, I have a folder path set up, and everytime I pull data from that path, it pulls up a file that I cant seem to locate or figure out what it is.
'.DS-Store': A few online threads said it had to with the excel type, but this FILE CANT BE SEEN, so I DONT UNDERSTAND how I could possibly change something that isnt there.
Screenshot of PowerQuery Editor:
Screenshot of Folder:
ANY AND ALL HELP WOULD BE MUCH APPRECIATED!
Thank you