Forum Discussion
Loading data from folder, different sheet names
here is link to pbix file , it has two functions, read sheets from excel files and then read data from each sheet in excel file.
feel free to reach out if you need further help./
https://drive.google.com/file/d/0B4dPgH9_BPBraFhtTVdnd05OSnM/view?usp=sharing
Hi!
I'm still a novice at Power BI, but I'm trying to figure out how to properly use your functions. Am I supposed to copy and paste the M language in the Advanced Editor for each function into my own PBIX file where my data is at? And then from there, once it's been set up, what are my next steps?
Similar to the person who posted this question, I have several excel files where the format is the same (Profit Loss statements), but each tab represents a different entity for the P-L. I'm trying my best to transform them, but my prior attempts don't go anywhere. I'm curious to see if your solution works, but I don't know how to use your functions. I'd so appreciate a walk-through step-by-step, especially since I've been using Power Bi for only two weeks :)
Thanks!
I don't know if this will help your use case, but it helped me -
https://www.howtoexcel.org/power-query/how-to-import-multiple-files-with-multiple-sheets-in-power-query/
Anonymous wrote:Hi!
I'm still a novice at Power BI, but I'm trying to figure out how to properly use your functions. Am I supposed to copy and paste the M language in the Advanced Editor for each function into my own PBIX file where my data is at? And then from there, once it's been set up, what are my next steps?
Similar to the person who posted this question, I have several excel files where the format is the same (Profit Loss statements), but each tab represents a different entity for the P-L. I'm trying my best to transform them, but my prior attempts don't go anywhere. I'm curious to see if your solution works, but I don't know how to use your functions. I'd so appreciate a walk-through step-by-step, especially since I've been using Power Bi for only two weeks :)
Thanks!
Hi - Did you ever find the solution for this?Many thanks
