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
Hello,
I had to delete the last step, because it was requiring column from your files, and it seems to work now :)
Thanks a lot again Sir.
Sabedin
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,
This post together with my excperience confirm that Microsoft Power BI cannot import several excel files with different sheet names through import folder. Is it true?
The solution of this post may work, but it is not generalized for all similar cases. I look forward to a genearl solution for this problem. 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
